I have searched for many days on google on this. And I have learned quite a bit. I'm stuck on one part of my code I cannot get to work.

i have a field called `allgenreid` which list all the game genres by numerical id (eg. 1,2,3,4,5 ... 200)

I used to use the following

Code:
SELECT * FROM table_name WHERE `allgenreid` LIKE '%$id%'
however this returns many undesirable results. If i am looking for gamegenre...