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