SELECT
id,
summary_show AS summary,
clusters_counts AS clustersCounts
FROM
model_clustering
WHERE
show_id = 'all'
AND STATUS = '1'
AND to_days( create_time ) = to_days( now( ) )
ORDER BY
CAST( `clusters_counts` AS DECIMAL ) DESC
LIMIT 10
mysql varchar类型 order by 排序
于 2022-05-25 10:15:28 首次发布