[SOLVED] Reverse LIKE statement

[e1seix]

I've done something very stupid... I have a variable which is a series of numbers seperated by commas

 

$sub='11,14,16';

 

Each number is a sub category for a section on my website however, in my databse they are all assigned seperately

 

11=non-fiction
14=autobiography
16=english

 

problem now stands that i can't figure out how to reverse search my database to define if the page on which the variable $sub is present, it will display the relevant category.

 

$qrySub=mysql_query("SELECT * FROM categories WHERE sub LIKE '%$sub%'")or die(mysql_error());

 

This doesn't work because obv. '11,14,16' as a string is not like each individual entry ie. '11', '14', '16'.

 

How can I reverse it around?

 

Cheers!

[Mchl]

WHERE sub IN ($sub)