為此，將ORDER BY子句與CASE語句一起使用。讓我們首先創建一個表-mysql>?create?table?DemoTable1610

->?(

->?Marks?int,

->?Name?varchar(20)

->?)?;

使用插入命令在表中插入一些記錄-mysql>?insert?into?DemoTable1610?values(85,'John');

mysql>?insert?into?DemoTable1610?values(78,'Carol');

mysql>?insert?into?DemoTable1610?values(78,'John');

mysql>?insert?into?DemoTable1610?values(85,'Carol');

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

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

|?Marks?|?Name??|

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

|????85?|?John??|

|????78?|?Carol?|

|????78?|?John??|

|????85?|?Carol?|

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

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

這是使用MySQL中兩個不同的列進行自定義排序的查詢-mysql>?select?*?from?DemoTable1610

->?order?by?Marks,case?when?Name='Carol'?then?1?else?0?end;

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

|?Marks?|?Name??|

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

|????78?|?John??|

|????78?|?Carol?|

|????85?|?John??|

|????85?|?Carol?|

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

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