MySQL SELECT rows matching Array? [duplicate]

Question

Possible Duplicate:
PHP/MYSQL using an array in WHERE clause

I have an array called $ids:

Array ( [0] => 14  [1] => 15 [2] => 16 [3] => 17 [4] => 18 [5] => 19)

I want to select from table Users where ID matches any value on the array. How can this be done?

v2p · Accepted Answer · 2011-11-21 08:55:24Z

up vote 11 down vote accepted

Something like this:

$values = implode(',', $ids);
$sql = "SELECT * FROM Users WHERE ID IN ($values)";

edited Nov 21 '11 at 8:55

answered Nov 20 '11 at 23:58

v2p
1,815613

Thanks V2p... just what I was looking for today!!! – Daniel Hunter Jan 25 '12 at 0:31

marked as duplicate by Michael Berkowski, Aurelio De Rosa, Aron Rotteveel, ajreal, Matt Nov 21 '11 at 9:43