MySQL合并多行数据并且判断某个字段是否包含某个字符

在mysql脚本中使用聚合函数合并一行后，判断某一个字段的值是否包含某个值

// GROUP_CONCAT
SELECT
	i.id,
i.name,
i.id_card_no,
i.mobile,
i.student_no,
i.employee_name,
//SUM函数：俩字段合并并且俩值相加
SUM(c.contract_amount) AS contractAmount,
SUM(t.paid_fee) AS paidFee,
//IF(LOCATE('2',GROUP_CONCAT(t.fee_status))>0,2,1),先将int类型字段合并成字符串后，再用LOCATE()判断是否包含
//字符2，如果包含就大于0，该字段就取值为2，不包含就小于0，取值为1
IF(LOCATE('2',GROUP_CONCAT(t.fee_status))>0,2,1) AS fee_status,
//GROUP_CONCAT(),将某一张表中的字段合并成字符串
GROUP_CONCAT(c.business_type) AS businessType
FROM
	t_b_training_student_info i
	LEFT JOIN t_b_training_student_training t ON t.student_id=i.id AND t.`enable`=1
	LEFT JOIN t_b_training_contract_info c ON c.student_id=i.id and c.`enable`=1
	where i.id='7bd70c43220b4baca9ca856bef2b149a' AND i.enabled=1
	GROUP BY
		i.id,i.name,
i.id_card_no,
i.mobile,
i.student_no,
i.employee_name