insert overwrite table sogou_20111230_limit3 select * from sogou_20111230 limit 3;
select * from sogou_20111230 m join sogou_20111230_limit3 n on m.uid=n.uid;//n表中的3个uid在m表中搜索过的所有记录
select m.uid,m.keyword from sogou_20111230 m join sogou_20111230_limit3 n on m.uid=n.uid;//n表中的3个uid在m表中搜索过的所有记录,把uid与keyword两个字段取出来
搜索过仙剑奇侠传的用户还搜索过什么内容
(1)搜索过仙剑奇侠传的用户
select distinct uid from sogou_20111230 where keyword like '%仙剑奇侠传%'
(2)还搜索过什么内容
select m.uid,m.keyword from sogou_20111230 m join(select distinct uid from sogou_20111230 where keyword like '%仙剑奇侠传%') n on m.uid=n.uid where m.keyword rlike '~(.*仙剑奇侠传.*)';//未能实现
select m.uid,m.keyword from sogou_20111230 m join(select distinct uid from sogou_20111230 where keyword like '%仙剑奇侠传%') n on m.uid=n.uid where m.keyword not like '%仙剑奇侠传%';