sql - How to search for a substring in SQLite?

Question

Whats the most efficient way to search for a sub string in SQLite?

I'm looking at the LIKE operator.

Do I have the right idea? Has this worked well for you?

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

Thank You.

question from:https://stackoverflow.com/questions/3671761/how-to-search-for-a-substring-in-sqlite

Answer 1

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