Android sqlite query for string

Question

Cursor cursor = db.rawQuery("SELECT id,lastname FROM people WHERE lastname='John Kenedy'; ",null);

Is that correct usage of comparing String ? if no, How can I compare String values in the database?

you can use "=" for straight string comparisons, there's also LIKE, GLOB, REGEXP and MATCH (if you are using a free-text search table/fts3) - what is your use case? Oh, and btw, performance is improved by SQLiteStatements - not tweaking rawQuery with parameters - that just prevents injections. — Jens
– Jens, Commented Jun 3, 2012 at 22:59

Simon Dorociak · Accepted Answer · 2012-06-03 22:55:33Z

7

For better performance, you should use rawQuery method with selectionArgs which is faster and more secure against adding directly data to statement. So try it like this

Cursor cursor = db.rawQuery("SELECT id,lastname FROM people WHERE lastname = ?; ", new String[] {"John Kenedy"});

edited Jun 3, 2012 at 22:55

answered Jun 3, 2012 at 22:40

Simon Dorociak

33.5k10 gold badges70 silver badges107 bronze badges

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

Collectives™ on Stack Overflow

Android sqlite query for string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related