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.