android - How to use rawQuery() with a WHERE clause to find a specific date from a given column? -

i have query mentioned below, getting cursor return 0 when use getcount() function on cursor.

please me query written properly.

string dt_value = setalarm.today_date; sqlitedatabase sqldb = this.getwritabledatabase(); cursor c = sqldb.rawquery("select * name date= " +dt_value ,null); return c; 

my dt_value value 16-08-08 , value available @ 4th column of table name, when call function c.getcount() getting count 0.

try use modified query

cursor c = sqldb.rawquery("select * name date='"+dt_value +"'",null);