mysql字段内容用逗号隔开，查询包含指定内容的命令

原生语句 多个字段需要查询用or

SELECT * FROM `tp6_work_order` WHERE  ( (  (FIND_IN_SET(1, head_user_id) or FIND_IN_SET(1, check_user_id) or FIND_IN_SET(1, edit_user_id)) ) )
1

tp6条件写法

$where = [];
$find_in_set_where = "(FIND_IN_SET(" . $user['id'] . ", head_user_id) or FIND_IN_SET(" . $user['id'] . ", check_user_id) or FIND_IN_SET(" . $user['id'] . ", edit_user_id))";
$where[] = [
   ["", "exp", Db::raw($find_in_set_where)],
];

$work_order = Db::name('work_order')
            ->where($where)
            ->select();
1
2
3
4
5
6
7
8
9