locate查找字符串是否存在
列子:查找A.follow_up_plan 为5是否存在
SELECT * FROM base_potential_client_info AS A LEFT JOIN base_sys_user AS B ON A.account_manager_id = B.id WHERE locate('5', A.follow_up_plan) > 0
列子:查找A.follow_up_plan 为5是否存在
SELECT * FROM base_potential_client_info AS A LEFT JOIN base_sys_user AS B ON A.account_manager_id = B.id WHERE locate('5', A.follow_up_plan) > 0