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

 

posted @ 2021-03-09 14:40  $Elvin  阅读(64)  评论(0)    收藏  举报