更新时间:2022-05-04 06:50:34
MySQL order by case 解决方法字母顺序应该是A-Z包含# 正序排列,#号排到了前面的问题
SELECT * FROM customer_info ORDER BY cus_name_index ASC;
SELECT * FROM customer_info
ORDER BY
CASE WHEN cus_name_index = '#' then cus_name_index END ASC,
CASE WHEN cus_name_index != '#' then cus_name_index END ASC;
问题完美解决。