SELECT * from hdsl_process_hiddendanger hiddendanger order by IF(REPORT_UNIT= 102 , SUBSTRING(SUBSTRING_INDEX(HIDDENDANGER_NUM, '-', 1), 6, 7), SUBSTRING(SUBSTRING_INDEX(HIDDENDANGER_NUM, '-', 1), 3, 7)) desc limit 1
mysql 截取字段排序
最新推荐文章于 2024-07-20 16:33:27 发布