SQL求助

[杀猪剑客]

sql小测试：有张表pages 列：id , url , content , body
类型：id --int 后面3个varchar
现在要求查询：url 中包含google字符串的显示在最上面，body的显示在中间，content的显示在最下面，请使用一条语句查询！

[我用一世换你一生]

看了才发现，我觉的挺难

[luckyzhangye]

[tastypinenut]

select * from pages where id in ( -- get all records
   select distinct id from pages where id in ( --remove duplicate records
     select id from pages where url like '%google%' --url contains 'google'
     union all 
     select id from pages where content like '%google%'  --content contains 'google'
     union all 
     select id from pages where body like '%google%'  --body contains 'google'
   )
)

[gukuitian]

select url,body,content
       decode(instr(url, 'google'),
              0,
              decode(instr(body, 'google'),
                     0,
                     decode(instr(content, 'google'), 0, 4, 3),
                     2),
              1) type_order
  from pages 
 order by type_order

[SasONsoft]

mark，回来再看~

[杀猪剑客]

可以用union all 来做！
（select id from pages p where p.url="google"） union all (select id from pages p where p.body = "google") union all (select id from pages p where p.content = "google");