Re: [請益] 字串排序
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
推
11/25 19:43, , 1F
11/25 19:43, 1F
討論串 (同標題文章)
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
0
18
