Mysql在Array中搜索字符串

Question

Data stored in the database as below where category is column name and comma separated strings are values.

category = 'cat,cat1,cat2,cat3,cat33,cat4';

I'm trying to search with a category from the list:

$query= mysqli_query($mysqli, "SELECT * FROM table where
INSTR(category,'cat3') > 1 ");

But this doesn't work because the result includes cat3 and cat33.

Any thoughts on how I can do this search, please?

Thanks!

Answer 1

"SELECT * FROM table where category LIKE '%cat3,%'";
"SELECT * FROM table where category LIKE '%cat33,%'";

if you don't want to add comma to the end of each category name, then "SELECT * FROM table where category LIKE '%cat3,%' OR category LIKE '%cat3'";