WHERE IN problem

[mapleleaf]

I am trying to check if an id is in a comma separated string in the database

 

I was using this:

$query = "SELECT * FROM articles ";
$query .= "WHERE second_theme
			IN ( ".$_POST['secondary_theme']." ) ";

 

$_POST['secondary_theme'] is an id and second_theme is the comma separated list.

What seems to be happenning is that if the id is the first in the comma separated list it will return it. If 2nd or 3rd it won't be returned?

 

Did I misunderstand WHERE IN??

 

 

 

 

 

 

[rajivgonsalves]

try this

 

$query = "SELECT * FROM articles ";
$query .= "WHERE FIELD_IN_SET  ( ".$_POST['secondary_theme'].",  second_theme) ";

 

the IN will compare the whole field value with the posted value

 

 

[mapleleaf]

I get this:

#1305 - FUNCTION dbarticles.FIELD_IN_SET does not exist

 

when running this sql:

 

SELECT * FROM articles WHERE FIELD_IN_SET( 1, second_theme)

 

 

in the message dbarticles is the database name.

 

What is wrong?

[PFMaBiSmAd]

It's actually FIND_IN_SET, not FIELD_IN_SET and the first parameter needs to be enclosed in single-quotes.

[mapleleaf]

Thanks a lot PFMaBiSmAd!!

That was what I was looking for!!