title: android sqlite.query not returning the row
body: <p>A row has been inserted into the sqlite database via some UI action. I can see the row if I drop to <code>adb shell</code>, but not able to retreive it back in the android code.</p>
  <p>Can you please let me know what could be a possible issue?</p>
  <pre><code>    String selectQuery = &quot;SELECT  * FROM daily  WHERE day = \&quot;Sun\&quot;&quot;;
      Log.d(&quot;DBLOG&quot;, selectQuery);
      Cursor c = db.rawQuery(selectQuery, null);
      Log.d(&quot;DBLOG&quot;, &quot;&quot; + c.getCount());
  </code></pre>
  <p>In adb shell, I dropped to sqlite3 prompt and can see the result for the exact same query.</p>
  <h3>Update:</h3>
  <p>Ok maybe date is not being used correctly by me. But even tough querying on other field also gives no output.
  <a href="https://i.stack.imgur.com/JYOoP.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JYOoP.jpg" alt="enter image description here" /></a></p>