Convert String into MySQL Query

Question

I have this string in PHP:

$str = 1,3,6,5

These numbers can change and the length of the set can change to more or less than four. I want to convert to a MySQL query like this in PHP:

$qry = mysql_query("SELECT * FROM tbl WHERE id = 1 or id = 3 or id = 6 or id = 5")

It should be easy, but I don't know how to do it.

I will be grateful for any help.

xdazz · Accepted Answer · 2012-09-20 02:47:13Z

5

You could use IN.

$query = mysql_query("SELECT * FROM table WHERE id IN ($str)");

Make sure $str is validated first to prevent sql injection.

answered Sep 20, 2012 at 2:47

xdazz

161k38 gold badges255 silver badges278 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Would having a loop casting all values to int be sufficient ?