SQLite query to match text string in column

sql sqlite

You can use wildcard characters: %

select * from table where name like '%BMW%'

sql sqlite

I think you are looking for something like

SELECT * FROM TableWHERE Column LIKE '%BMW%'

the % are wildcards for the LIKE statement.

More information can be found HERE

sql sqlite

select * from table where name like '%BMW%'

CodeHunter