How to get all the items in sql using query based on a WHERE clause

Question

I am new to database and I am trying to get all the data from table whose category column is equal to 1. This is my first attempt. Can someone please guide me where I am doing wrong?

public Cursor getAllFamilyMovies()
    {
        return database.query("movies", new String[] {"_id", "name"},
                "category=1", null, null, null, "name");
}

score 1 · Accepted Answer · edited Jul 18 '16 at 22:45

1

The "whereclause" and "whereargs" need to be separated as shown below:

public Cursor getAllFamilyMovies() {
    return database.query("movies", new String[] {"_id", "name"}, "category = ?", new String[] {"1"}, null, null, "name");
}

edited Jul 18 '16 at 22:45

guipivoto

18,327
9
60
75

answered Jul 18 '16 at 22:42

hello404

22
2

This works only if the values in the `category` column actually are strings. – CL. Jul 19 '16 at 07:36

How to get all the items in sql using query based on a WHERE clause

1 Answers1