> For example: > > gallery_id | gallery_name | keywords > 1 | test | 1,2,3,4 > 2 | test2 | 3,4,5,6 > > And I won't to get all the galleries with where the have the > keywords 2, which in this case would be record 1 or keyword 4 > which would be both record. > > SELECT gallery_id, gallery_name > FROM galleries > WHERE keywords ???? >
SELECT gallery_id, gallery_name FROM galleries WHERE keywords LIKE '%2% Or if you want to avoid the above picking up keywords 12, 20, 21, 22 etc... And each keyword is seperated with a comma then SELECT gallery_id, gallery_name FROM galleries WHERE keywords LIKE '%2,% Cheers Dean -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]