TP5 find_in_set用法

tp5.0

//值为数字
$id=419;
$where[] = ['exp',Db::raw("FIND_IN_SET($id,category)")];//category值为数字，例子：419,415,414
//值为字符串
$id值等于dfd 要注意'引号
$where[] = ['exp',Db::raw("FIND_IN_SET('$id',category)")];//category值为数字，例子：'349/417/419','349/413/415','349/413/416'


Db::name('menu')->where('FIND_IN_SET(:id,pid_all)',['id' => $id])->update([$field => $title]);

tp5.1

 $department_id=intval($post['department_id']);
 $where[] = ['','exp',Db::raw("FIND_IN_SET($department_id,a.join_bm)")];

   $where[] = ['', 'exp', db()->raw("FIND_IN_SET({$labelId},label)")];