I am using find_in_set with my query to get data from comma separated field. But it shows me error.
$results = DB::select("SELECT basic.updated_at,basic.updated_by,,ccbi.team_group_id,basic.id
FROM basic_info as basic
INNER JOIN emp_info as emp_details
ON basic.emp_master_id = emp_details.emp_id
WHERE basic.id IN (SELECT basic.id FROM basic_info as basic WHERE basic.updated_at = (SELECT MAX(basic.updated_at) FROM basic_info as basic)) AND basic.team_id = '1' AND ('FIND_IN_SET(?,emp_details.emp_grp)' , '18') ORDER BY basic.id DESC LIMIT 1");
above query shows me error of :
Cardinality violation: 1241 Operand should contain 1 column(s)
If i will remove AND ('FIND_IN_SET(?,emp_details.emp_grp)' , '18')
this part it will return correct result.