SQLite query to match text string in column
sql, sqlite
Solution
You can use wildcard characters: `%`
select * from table
where name like '%BMW%'
Problem
I have a database column that contains text in CSV format. A sample cell looks like this: ``` Audi,Ford,Chevy,BMW,Toyota ``` I'd like to generate a query that matches any column with the string 'BMW'. How can I do this in SQL?