Sort
-
MySQL/한글, 영문, 숫자, 특문 정렬방식DBMS/MySql (MariaDB) 2021. 3. 17. 10:22
프로젝트에서 필요한 부분이 있어서, 샘플로 만들어 보았습니다. WITH t_temp AS ( SELECT 1 AS product_name UNION ALL SELECT '&_@' UNION ALL SELECT 'B%#$' UNION ALL SELECT 'a%#$' UNION ALL SELECT '^SA' UNION ALL SELECT '남dsfa$%' UNION ALL SELECT '강2f23bvc43' UNION ALL SELECT '뷁2f23bvc43' UNION ALL SELECT '뷁1f23bvc43' UNION ALL SELECT '뷁11f23bvc43' UNION ALL SELECT '뷁3f23bvc43' ) SELECT xxx.product_name, ASCII(SUBSTRING(xxx.pr..