need help in simple search query

[netmastan]

Hi,
I got a list table and it has field called cat.
cat field is a text type and hold categories id in comma delimited format ie 1,4,7
where 1,4, 7 are cat id. I know i should have used list-cat table.

I would like to search list table

$cat=intval($_GET["cat"]);
$result=$db->query("SELECT * FROM list WHERE  $cat in (listcat)");

I get zero result

Any help?

[Piranha]

Normalize the database. It might be a bit work, but you will gain time and effort in the long run to do it.

[toxic_brain]

what is listcat