62,042
社区成员
发帖
与我相关
我的任务
分享
create table book(
BookID int,
BookName varchar(50),
BookDesc varchar(50))
insert book
select 9,'net入门','親啟'
union all
select 6,'net入门','abcd'
union all
select 7,'xxx','net入门'
union all
select 8,'哈哈','美美'
--模糊查询,相关度排序
select * from Book where BookName like '%Net入门%' or BookDesc like '%Net入门%'
ORDER BY CASE WHEN BookName like '%Net入门%' THEN 1
WHEN BookDesc like '%Net入门%' THEN 2
END
select * from tablename
order by case when id=0 then 0 else 1 end
Select *,Case When title like '%CSDN%' Then 1 Else 0 End orderKey From Table
Order By orderKey Desc
SELECT* FROM VW_FC_ALL_Chipin_Current ORDER BY (CASE when id>30 THEN 1 ELSE 2 END )