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?

http://www.sqlite.org/lang_expr.html

Thanks.

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.