title: How to get all the items in sql using query based on a WHERE clause
body: <p>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?</p>
  
  <pre><code>public Cursor getAllFamilyMovies()
      {
          return database.query("movies", new String[] {"_id", "name"},
                  "category=1", null, null, null, "name");
  }
  </code></pre>