Android SQLite Query and using cursor to filter and order rows
<p>Currently I am making android program which filters rows based on name using <strong>where</strong> query, however when I use it together with <strong>order by</strong> query (time), ordering doesn't work. If I just use order by without WHERE it works fine.</p>

<pre><code>String WHERE="name LIKE'%John%';";

Cursor cur = db.query("tbl_schedule", 
            null, WHERE, null, null, null, "time");
</code></pre>
