CODEWITHSUNDEEP
androidsqlitesql-like
Soo
Soo

Reputation: 57

android sqlite 'like' query and modulo expression

when i use LIKE query in android sql, i want 'contains' query about some input.

db.query(TABLE,
         new String[]{COLUMN},
         CONDITIONS + " LIKE " + "?",
         new String[]{("%" + input + "%")},
         null
         null
         ORDER_COLUMN + " DESC",
         null);

query is working well, but when i use '%' character in input, it working like empty string.

i want use '%' character which like normal string.

how can i do..?

thanks.

Upvotes: 0

Views: 220

Answers (1)

laalto
laalto

Reputation: 152817

Use the LIKE y ESCAPE z form to specify an escape character for the LIKE expression, and then use that escape character to prefix any % in your LIKE expression that needs to be taken literally. For example:

sqlite> create table t(a);
sqlite> insert into t values('a%b');
sqlite> insert into t values('ab');
sqlite> insert into t values('aa%bb');
sqlite> select * from t where a like '%a\%b%' escape '\';
a%b
aa%bb

Upvotes: 2

Related Questions