[SOLVED] mysql "SELECT x IN (x,y,z)"

[thedarkwinter]

hi

im trying to select * from a table where a variable represents 1 tag, and the item in the database has a list of tags:

 

For instance, my variable is 3. There are some records where tag (varchar) is "2,3,4" or maybe just "1,5" etc.

SELECT * FROM table WHERE (3 in (tags) );

returns 0 results.

 

Any ideas?

 

Thanks in advance!

[fenway]

How?

[Illusion]

try this

SELECT * FROM table WHERE if(FIND_IN_SET('3',tags ),TRUE,FALSE);

[teng84]

SELECT * FROM table WHERE field in ('x','y','z');