SQLite query to match text string in column

Question

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?

Answer 1

You can use wildcard characters: %

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

Answer 2

I think you are looking for something like

SELECT * FROM Table
WHERE Column LIKE '%BMW%'

the % are wildcards for the LIKE statement.

More information can be found HERE

Answer 3

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

Answer 4

Another Way...

--Create Table 2 :
Create Table #Table1
(
    Roll_No INT, 
    Student_Address Varchar(200)
)
Go

-- Insert Values into #Table1: 
Insert into #Table1 Values ('1','1st Street')
Insert into #Table1 Values ('2','2rd Street')
Insert into #Table1 Values ('3','3rd Street')
Insert into #Table1 Values ('4','4th Road')
Insert into #Table1 Values ('5','5th Street')
Insert into #Table1 Values ('6','6th Street')
Insert into #Table1 Values ('7','7th Street')
Insert into #Table1 Values ('8','8th Wing')

--Query
Select * from #Table1 where CharIndex('Street',Student_Address) > 0

--Clean Up:
Drop table #Table1