MySQL常见sql汇总

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

例：SELECT * FROM `courseRecord` WHERE courseId='45' AND userId IN (420266,494538,523705,1251,596623,738412,1299,846277,173349,514828,675091,701357,738422,855201,633090,847005)；

　　SELECT * FROM `courseRecord` WHERE courseId='{$courseId}' AND userId  IN (" . implode(',',$classUserArray) . ");