select * from hold_card h left join hold_card b on h.my_mobile = '13000000000' where h.my_mobile = b.my_mobile and h.hold_name like '%lym%' or h.hold_mobile like '%lym%' or h.hold_extraname like '%lym%'
嘻嘻, 没看明白呀,感觉你的要求不需要连接呀SELECT * FROM ... WHERE mobile='13000000000' AND ( (hold_mobile LIKE '%lym%') OR (hold_name LIKE '%lym%') OR (hold_extraname like '%lym%') ):) 可能是我理解错了吧呵呵, 你将示例帖出来呢
select * from hold_card h left join hold_card b on b.my_mobile=h.my_mobile where h.hold_name like '%lym%' or h.hold_mobile like '%lym%' or h.hold_extraname like '%lym%'
没看明白呀,感觉你的要求不需要连接呀SELECT * FROM ...
WHERE mobile='13000000000'
AND (
(hold_mobile LIKE '%lym%')
OR (hold_name LIKE '%lym%')
OR (hold_extraname like '%lym%')
):)
可能是我理解错了吧呵呵,
你将示例帖出来呢