mysql中find_in_set的用法

主表中字段用左表主键逗号隔开联查

SELECT t1.*,group_concat(t2.role_name) from ful_admin_user t1 LEFT JOIN ful_admin_role t2 on FIND_IN_SET(t2.id,t1.role_ids) GROUP BY t1.id;

select * from ful_action_log where type = 5 and find_in_set("4",link_id);

tp5 这样使用 find_in_set

empty($parameter['link_id']) ? : $map[] = ['','exp',Db::raw("FIND_IN_SET({$parameter['link_id']},al.link_id)")];