bavs

I agree, the design is not good but I didn't do it, just trying to work with it. where category like '%,12,%' does not work because it doesn't pick up rows where 12 is first number or only number.

I am trying to create a select statement and keep running into problems I have a table with columns id int client text category text Category contains a list of ids so examples are 1,3,12,16,20 12,25,17,122 23,122 12 I am trying to count the number of rows that contain a number in the category ie contain 12 and I expect to get 3 rows but can't get it to work select count(*) from clients where category in ('12') only returns 1 but where category like '%12%' returns 4 I'm stuck, please help.