SQLite Select from where column contains string?

by

SELECT * FROM users WHERE column LIKE '%mystring%' will do it.

LIKE means we’re not doing an exact match (column = value), but doing some more fuzzy matching. “%” is a wildcard character – it matches 0 or more characters, so this is saying “all rows where the column has 0 or more chars followed by “mystring” followed by 0 or more chars”.

Leave a Comment