find_in_set()

类似于查找list集合中的某个数据

SELECT
 * 
FROM
yb_employee_dict
WHERE
FIND_IN_SET('测试',name)

SELECT * FROM yb_employee_dict

SELECT
 * 
FROM
yb_employee_dict
WHERE
FIND_IN_SET(name,'测试,陆静娟')

SELECT
 * 
FROM
yb_employee_dict
WHERE name IN('测试','陆静娟')