sql 多关键词 排序

发布网友 发布时间：2022-05-02 20:36

我来回答

共2个回答

热心网友 时间：2022-06-26 23:24

select Two_ClassID,N_ID,N_Titl,N_Date from (select 0 AS nid,Two_ClassID,N_ID,N_Titl,N_Date FROM News_Content where N_Title like '%冰冰%' Union select 1 AS nid,Two_ClassID,N_ID,N_Titl,N_Date FROM News_Content where N_Title like '%老外%' Union select 2 AS nid,Two_ClassID,N_ID,N_Titl,N_Date FROM News_Content where N_Title like '%合作%' Union select 3 AS nid,Two_ClassID,N_ID,N_Titl,N_Date FROM News_Content where N_Title like '%融洽%' Union select 4 AS nid,Two_ClassID,N_ID,N_Titl,N_Date FROM News_Content where N_Title like '%杰克曼%' Union select 5 AS nid,Two_ClassID,N_ID,N_Titl,N_Date FROM News_Content where N_Title like '%再教%' Union select 6 AS nid,Two_ClassID,N_ID,N_Titl,N_Date FROM News_Content where N_Title like '%全智贤%') A order by nid;

括号外面给表起个别名就可以了

热心网友 时间：2022-06-26 23:24

试试这个
select Two_ClassID, N_ID, N_Titl, N_Date
from (select 0 AS nid, Two_ClassID, N_ID, N_Titl, N_Date
FROM News_Content
where N_Title like '%冰冰%'
Union
select 1 AS nid, Two_ClassID, N_ID, N_Titl, N_Date
FROM News_Content
where N_Title like '%老外%'
Union
select 2 AS nid, Two_ClassID, N_ID, N_Titl, N_Date
FROM News_Content
where N_Title like '%合作%'
Union
select 3 AS nid, Two_ClassID, N_ID, N_Titl, N_Date
FROM News_Content
where N_Title like '%融洽%'
Union
select 4 AS nid, Two_ClassID, N_ID, N_Titl, N_Date
FROM News_Content
where N_Title like '%杰克曼%'
Union
select 5 AS nid, Two_ClassID, N_ID, N_Titl, N_Date
FROM News_Content
where N_Title like '%再教%'
Union
select 6 AS nid, Two_ClassID, N_ID, N_Titl, N_Date
FROM News_Content
where N_Title like '%全智贤%' ) as t
order by t.nid;
试试这个