mysql数组

Question

$user_id = array(1,2,3);

mysql语句应该怎么写可以得到下面一样的效果？
$sql = "select * from users where user_id in(1,2,3) ";

我想到遍历$user_id数组，$str = $str. "," . $v;
$sql = "select * from users where user_id in($str) ";
有没有简单直接一点的语句？

Answer 1

$user_id = implode(',',$user_id);