Android quotes within an sql query string
You should make use of the rawQuery
method's selectionArgs
parameter:
p_query = "select * from mytable where name_field = ?";mDb.rawQuery(p_query, new String[] { uvalue });
This not only solves your quotes problem but also mitigates SQL Injection
.