MySQL - 排序语法

87A7827C-3364-4B1F-A90D-699CAB6159B9.png

查询ORDER BY|升序ASC (低->高)

SELECT u.user_name ,u.user_weigh FROM tb_user u ORDER BY u.user_weigh ASC;

查询ORDER BY|降序 DESC (高->低)

SELECT u.user_name ,u.user_weigh FROM tb_user u ORDER BY u.user_weigh DESC;

多列排序

SELECT u.user_name, u.user_age, u.user_weigh, u.user_change 
FROM tb_user u 
ORDER BY u.user_age ASC,u.user_weigh DESC;

模糊 + 升序查询

SELECT u.user_name, u.user_age, u.user_weigh, u.user_weigh *10 as _weight FROM tb_user u 
WHERE u.user_name LIKE "%C%"  
ORDER BY _weight ASC;