<if test="ecoEnvQualDustBaseMonInfoDTO.pm25Order!=null and ecoEnvQualDustBaseMonInfoDTO.pm25Order == 1 ">
order by cast(pm25 as signed) asc
</if>
<if test="ecoEnvQualDustBaseMonInfoDTO.pm25Order!=null and ecoEnvQualDustBaseMonInfoDTO.pm25Order == 2 ">
order by cast(pm25 as signed) desc
</if>
<if test="ecoEnvQualDustBaseMonInfoDTO.pm10Order!=null and ecoEnvQualDustBaseMonInfoDTO.pm10Order == 3 ">
order by cast(pm10 as signed) asc
</if>
<if test="ecoEnvQualDustBaseMonInfoDTO.pm10Order!=null and ecoEnvQualDustBaseMonInfoDTO.pm10Order == 4 ">
order by cast(pm10 as signed) desc
</if>
mysql排序 及 字符串转换数字
最新推荐文章于 2024-07-01 13:54:09 发布