以下是使用ORDER BY實現多個LIKE運算符的語法-select?*from?yourTableName

order?by

(

yourColumnName?like?'%yourValue1%'

)

+

(

yourColumnName?like?'%yourValue2%'

)

+

.

.

N

desc;

讓我們創建一個表-mysql>?create?table?demo2

?>?(

?>?id?int?not?null?auto_increment,

?>?name?varchar(100),

?>?primary?key(id)

?>?);

借助insert命令將一些記錄插入表中-mysql>?insert?into?demo2(name)?values('John');

mysql>?insert?into?demo2(name)?values('David');

mysql>?insert?into?demo2(name)?values('John?Smith');

mysql>?insert?into?demo2(name)?values('John?Doe');

mysql>?insert?into?demo2(name)?values('David?Miller');

mysql>?insert?into?demo2(name)?values('Chris');

mysql>?insert?into?demo2(name)?values('Bob?Doe');

使用select語句顯示表中的記錄-mysql>?select?*from?demo2;

這將產生以下輸出-+----+--------------+

|?id?|?name?????????|

+----+--------------+

|??1?|?John?????????|

|??2?|?David????????|

|??3?|?John?Smith???|

|??4?|?John?Doe?????|

|??5?|?David?Miller?|

|??6?|?Chris????????|

|??7?|?Bob?Doe??????|

+----+--------------+

7?rows?in?set?(0.00?sec)

以下是對多個LIKE運算符的查詢-mysql>?select?*from?demo2

?>?order?by

?>?(

?>?name?like?'%Doe%'

?>?)

?>?+

?>?(

?>?name?like?'%David%'

?>?)?desc;

這將產生以下輸出-+----+--------------+

|?id?|?name?????????|

+----+--------------+

|??2?|?David????????|

|??4?|?John?Doe?????|

|??5?|?David?Miller?|

|??7?|?Bob?Doe??????|

|??1?|?John?????????|

|??3?|?John?Smith???|

|??6?|?Chris????????|

+----+--------------+

7?rows?in?set?(0.00?sec)

總結

以上是生活随笔為你收集整理的mysql order by 运算_在MySQL中具有ORDER BY的多个LIKE运算符？的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。