MySQL CAST 문자→숫자 정렬

CAST (문자 숫자 정렬)

VARCHAR에 숫자 문자열이 있으면 문자 정렬됨 → CAST.

SELECT * FROM t ORDER BY CAST(col AS UNSIGNED);
SELECT CAST('1' AS UNSIGNED);
SELECT CAST(2 AS CHAR(1));
-- 타입: BINARY, CHAR, SIGNED, UNSIGNED, DATE, DATETIME, TIME