select 1 as ID, visit_time, visit_url, phone_number, count(*) as visit_count
from access_log WHERE 1 = 1
and phone_number like '135%'
( or phone_number like '136%'
or phone_number like '137%'
or phone_number like '138%'
or phone_number like '139%' )
AND year(visit_time) = '2004'
AND month(visit_time) = '7'
GROUP BY dayofmonth(visit_time)
加个括号就行了。
from access_log WHERE 1 = 1
and phone_number like '135%'
( or phone_number like '136%'
or phone_number like '137%'
or phone_number like '138%'
or phone_number like '139%' )
AND year(visit_time) = '2004'
AND month(visit_time) = '7'
GROUP BY dayofmonth(visit_time)
加个括号就行了。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货