select
REPLACE(expire_time, -1, 3000)
from
t_test order by expire_time desc
select IF(expire_time = -1, 3000, expire_time) from
t_test order by expire_time desc
sql替换字段值后排序
最新推荐文章于 2024-07-20 17:22:43 发布
select
REPLACE(expire_time, -1, 3000)
from
t_test order by expire_time desc
select IF(expire_time = -1, 3000, expire_time) from
t_test order by expire_time desc