<div>
Use FIND_IN_SET:<br />
<br />
SELECT * from tablename<br />
WHERE 5 FIN_IN_SET (Ids)
</div>


Use FIND_IN_SET:

SELECT * from tablename
WHERE 5 FIN_IN_SET (Ids)

<div>
Thanks Todd<br />
<br />
But I get an error:<br />
<br />
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FIND_IN_SET(Ids)<br />
<br />
And I cannot find any MySql documentation about FIND_IN_SET. 
</div>


Thanks Todd

But I get an error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FIND_IN_SET(Ids)

And I cannot find any MySql documentation about FIND_IN_SET.

<div>
Ok, sorted it.<br />
<br />
SELECT * from tablename<br />
WHERE FIND_IN_SET (5, Ids)<br />
<br />
Regarding FIND_IN_SET documentation. The MySql website search gives no results, but Google finds lots of relevant pages from the MySql website!<br />
<br />
Thanks for your help<br />
<br />
John
</div>


Ok, sorted it.

SELECT * from tablename
WHERE FIND_IN_SET (5, Ids)

Regarding FIND_IN_SET documentation. The MySql website search gives no results, but Google finds lots of relevant pages from the MySql website!

Thanks for your help

John

<div>
Sorry about that - thanks for the points!
</div>


Sorry about that - thanks for the points!

<div>
<div class="content wysiwyg-content">
SELECT * from tablename<br />
WHERE 5 IN (Ids)<br />
<br />
Ids is a varchar containing either a single id, or a comma separated list of several ids.<br />
<br />
The above query works fine if Ids contains a single id (5 for example). But if Ids is a list (1,2,3,4,5), then the above query returns an empty result set, which is wrong.<br />
<br />
However the following query works on the same data:<br />
<br />
SELECT * from tablename<br />
WHERE 1 IN (Ids)<br />
<br />
So why does the query find 1 in the list (1,2,3,4,5), but not 5?<br />

</div>
</div>


SELECT * from tablename
WHERE 5 IN (Ids)

Ids is a varchar containing either a single id, or a comma separated list of several ids.

The above query works fine if Ids contains a single id (5 for example). But if Ids is a list (1,2,3,4,5), then the above query returns an empty result set, which is wrong.

However the following query works on the same data:

SELECT * from tablename
WHERE 1 IN (Ids)

So why does the query find 1 in the list (1,2,3,4,5), but not 5?


Problem with IN expression

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.