Instead of using the "=?" string to match strings exactly, use "like?":
db.query(TABLE_NAME, COLUMNS, REG_COLUMN + " LIKE? ", new String[] {searchQuery}, null, null, null);
instead of:
db.query(TABLE_NAME, COLUMNS, REG_COLUMN + "=? ", new String[] {searchQuery}, null, null, null);
Subscribe to:
Post Comments (Atom)
Thanks mate! I did solve my problem.
ReplyDeleteBetter solution: http://www.sqlite.org/lang_expr.html#collateop
ReplyDelete