Hi plusminus,

I have 1 query about the LIKE pattern in the SQL syntax, does the SQLite support that? If yes, how can i query that, can you give me an simple example code how to do that?

Thank you very much.
ddtdpro

according to the sqlite documentation, "like" expressions are valid and can be called as :

....where x like '%abc%'

is this not working in your case???

serkan.dogantekin wrote:according to the sqlite documentation, "like" expressions are valid and can be called as :

....where x like '%abc%'

is this not working in your case???

I know the syntax, but the thing is i don't know how to use it. I tried use rawQuery, but it always has error, i don't know how.

Using rawQuery() with "like" statements works just fine.
Post some code if you want help