语句如下:
SELECT hb_client.id, hb_client.company, hb_client.oper, hb_client.state, hb_client.diaocha, hb_client.sign_no, hb_client.import, hb_client.order_time
FROM hb_client
WHERE (
binaryucase( company )
LIKE ucase( '%恒聪%' ) OR oper
LIKE '%恒聪%' OR tel
LIKE '%恒聪%' OR linkman
LIKE '%恒聪%'
or address
LIKE '%恒聪%' OR url
LIKE '%恒聪%' OR email
LIKE '%恒聪%' OR re
LIKE '%恒聪%' OR corp_key
LIKE '%恒聪%'
) AND 1 = 1
ORDER BY import DESC , order_time DESC LIMIT 0, 30 会把没有恒聪两字的记录搜出来
SELECT hb_client.id, hb_client.company, hb_client.oper, hb_client.state, hb_client.diaocha, hb_client.sign_no, hb_client.import, hb_client.order_time
FROM hb_client
WHERE (
binaryucase( company )
LIKE ucase( '%恒聪%' ) OR oper
LIKE '%恒聪%' OR tel
LIKE '%恒聪%' OR linkman
LIKE '%恒聪%'
or address
LIKE '%恒聪%' OR url
LIKE '%恒聪%' OR email
LIKE '%恒聪%' OR re
LIKE '%恒聪%' OR corp_key
LIKE '%恒聪%'
) AND 1 = 1
ORDER BY import DESC , order_time DESC LIMIT 0, 30 会把没有恒聪两字的记录搜出来
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货