mysql数据库 查询字段值符合数组中的值的条目

比如这样的查询，数组中个数未知。

$array = array(1,40,20,55,29,48);

$sql = "SELECT * FROM `myTable` WHERE `myField`='$array'";

解决方案：
WHERE `myfield` IN (1,40,20,55,29,48)
Use implode to construct the string:
$sql = "SELECT * FROM `myTable` WHERE `myField` IN (" . implode(',', $array) . ")";