Sql ÅÅÐò - MS-SQL Server / »ù´¡Àà

ÎÒÏÖÔÚÓÖÕâÑùÒ»¸öÐèÇó ÓÐÒ»ÕÅ±í ±í ±íÃûBook
×ֶΠBookID BookName£¨ÊéÃû£© BookDesc £¨ÊéµÄ¼ò½é£© ÎÒÒª¸ù¾ÝÒ»¸ö¹Ø¼ü´Ê ÀýÈç NetÈëÃÅ ²éѯËùÓаüº¬Õâ¸ö¹Ø¼ü´ÊµÄ½á¹û
sql Óï¾ä select * from Book where BookName like '%NetÈëÃÅ%' or BookDesc like '%NetÈëÃÅ%'
ÎÒÒª¶Ô½á¹û½øÐÐÅÅÐò °ÑÊéÃûÖаüº¬ ¡®NetÈëÃÅ¡¯ µÄ½á¹û ÅÅÔÚ ÊéµÄ¼ò½éÖаüº¬ ¡®NetÈëÃÅ¡¯ µÄÇ°Ãæ ¿¼ÂÇ·ÖÒ³

---

SQL code:
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
ELSE 3
END

---

ÒýÓÃ

SQL code
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
E¡­¡­

KG¸çÕâ¸öÊÇ»ùÓÚʲôԭÀí°¡£¬Â¥Ö÷ÓÐûÓвâÊÔÊý¾Ý£¬»òÕßÂ¥Ö÷²âÊÔͨ¹ýÁËÂð£¬Ñ§Ï°°¡

---

1Â¥Õý½â£¬ÎÒ¸Õ¸Õ²âÊÔÁË ¡£
SQL code:

create table book(
BookID int,
BookName varchar(50),
BookDesc varchar(50))

insert book
select 1,'netÈëÃÅ','СÊÂ'
union all
select 2,'netÈëÃÅ','abcd'
union all
select 3,'xxx','netÈëÃÅ'
union all
select 4,'¹þ¹þ','ÃÀÃÀ'

select * from Bo