What is the best way to find a sub string in SQLite?

I am searching in the LIKE operator.

Have i got the best idea? Has this labored well for you personally?



You can use LIKE, however it will get really slow when the pattern you are trying to find begins with '%' -- i.e., when the substring you are searching for is not always at the outset of the area.

If you want to do such searches, think about using FTS3, making full-text searching substantially more effective.

Yepper, use Like. Select id from sometable where name like '%omm%' would return any row which had 'omm' any place in the title column.