mysql 查询语句相关

mysql 当一个字段是用逗号保存的其他id，如何连表查询出其他表详细信息 

SELECT * FROM `dj_huodong` as a left join dj_bumen_renyuan as b on FIND_IN_SET(b.id,a.canyu)

分组查询count(1)>2的数据

SELECT COUNT( 1 ) AS count1, shebei_id
FROM model
GROUP BY shebei_id
HAVING count1 >2

用逗号隔开查出来的id（GROUP_CONCAT）

GROUP_CONCAT(id)

 字段拼接concat

concat(",",id,",")
//,2,