mysql 字符串类型数字排序

时间:2022-05-28 20:08:09

排序字段+0,类似  Java 把 其他类型转换成字符串 比如 +“”;

SELECT
    b.tag_value AS NAME,
    sum(b.uv) AS
VALUE

FROM
    meta.dic_app_category a,
    rpt_app_cat_people b
WHERE
    a.id = b.`name`
AND a.id = 100
AND b.tag_name = 'active_hour'
GROUP BY
    b.tag_value
ORDER BY
    (b.tag_value + 0) ASC