sql²éѯ½á¹ûÅÅÐòÎÊÌâ - MS-SQL Server / »ù´¡Àà

sql ²éѯ½á¹ûÅÅÐòÎÊÌâ
ÏȲé³öÀ´µÄ·ÅÔÚ±íÇ°Ãæ

 ±ÈÈ磺ËÑË÷¹Ø¼ü×Ö £º'±±¾© ¸ß¿¼'
1¡£²éѯ½á¹û ͬʱ Æ¥Åä ¡°±±¾©¡±¡°¸ß¿¼¡±
select * from News where Title like '%±±¾©%' and ''Title like '%¸ß¿¼%'
2¡£Æ¥ÅäÒ»¸ö¹Ø¼ü×Ö 
select * from News where Title like '%±±¾©%' or ''Title like '%¸ß¿¼%'

ÎÊÌ⣺ÎÒÒª°ÑͬÊÂÆ¥Åä ±±¾© ¸ß¿¼ µÄ·ÅÔÚ×îÇ°Ã棬

---

SQL code:
select (case when Title like '%±±¾©%' then 1
when Title like '%¸ß¿¼%' then 2
when Title like '%±±¾©%' and ''Title like '%¸ß¿¼%' then 0
else 3 end) o,*
from News where Title like '%±±¾©%' and ''Title like '%¸ß¿¼%'
order by o

---

ÊÔÊÔ¿´
SQL code:
select * from News
where (Title like '%±±¾©%' and Title like '%¸ß¿¼%')
or Title like '%±±¾©%' or Title like '%¸ß¿¼%'
order by case when (Title like '%±±¾©%' and Title like '%¸ß¿¼%') then 0 else 1 end

---

SQL code:
select
(case when Title like '%±±¾©%' then 1
when Title like '%¸ß¿¼%' then 2
when Title like '%±±¾©%' and Title like '%¸ß¿¼%' then 0
else 3 end) o,*
from News where Title like '%±±¾©%' and ''Title like '%¸ß¿¼%'
order by o