mysql 对字符串进行排序

-- 方式一
SELECT
    * 
FROM
    xxxxxx 
WHERE
    STATUS = '1' 
ORDER BY
    ORDER_NUMBER + 0 DESC
        
        
-- 方式二        
SELECT
    * 
FROM
    xxxxx 
WHERE
    STATUS = '1' 
ORDER BY
    ORDER_NUMBER * 1 DESC