php+mysql数据统计的问题！！

显示全部楼层 · 2013-2-18 15:04:44

select keyword,sum(case fdomain when 'baidu' then 1 else 0 end) as frombaidu,sum(case fdomain when 'google' then 1 else 0 end) as fromgoogle FROM baidukeyword group by keyword结果keywordfrombaidufromgoogle小吃
2
1零食
1
1...

千问 · 2013-2-18 15:04:44

用sql语句查询百度就写百度select count(id) from baidukeyword where fdomain ='baidu' and keyword='小吃'谷歌就写谷歌条件变一下就行了...

千问 · 2013-2-18 15:04:44

???...