推 MOONRAKER:讚！ 11/25 19:43
mysql> select * from b order by name asc;
+------+
| name |
+------+
| a1 |
| a10 |
| a101 |
| a105 |
| a11 |
| a12 |
| a15 |
| a2 |
| a3 |
| a5 |
+------+
10 rows in set (0.01 sec)
mysql> select * from b order by abs(name) asc;
+------+
| name |
+------+
| a1 |
| a2 |
| a3 |
| a5 |
| a10 |
| a11 |
| a12 |
| a15 |
| a101 |
| a105 |
+------+
10 rows in set (0.00 sec)
--
3WA訓練家的工作室
宗旨：人生就是要爽
個人佈弱格 網址：http://3wa.tw
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 122.116.47.155