Hello

MP> Anyway it's tricky because I have to tell sqlite which index to use in
MP> LIKE to fast search but I do not have to tell the index if start with
MP> % or _ because otherwise the query is not executed.. I'll handle it...

I'm not sure if other people have suggested it already, but you can create
another field in your table to store the text you want to search reversed,
plus another index for this reversed field.

Then you can match rows using LIKE with the wildcard at the end of your
query while still using an index.

Swithun.

Reply via email to