query to retrieve data from sqlite by using = operator

Question

I am using a query to retrieve data from sqlite but I am getting an error.

I am using following query:

cursor = db.query ( TABLE_NAME, new String[] { EMPLOYEE }, USERID + " =  " + NAME, null, null, null, null );

Sarwar Erfan · Accepted Answer · 2011-03-09 11:26:05Z

1

db.query(TABLE_NAME, new String[] { EMPLOYEE },USERID + " = '" + NAME + "'" , null, null, null, null);

USERID seems to be a string type. So, the value you are comparing should be surrounded by single quote

answered Mar 9, 2011 at 11:26

Sarwar Erfan

18.1k5 gold badges48 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chirag · Accepted Answer · 2011-03-09 11:25:32Z

0

You can also retrieve data like this .

Cursor c = null;
        c = db.rawQuery("select field from tablename where field=" + your condition, null);

answered Mar 9, 2011 at 11:25

Chirag

56.9k29 gold badges155 silver badges199 bronze badges