查询pro_no长度为10
select ifnull(max(a.pro_no),0) as maxIndex from t_config_lib a where a.pro_no like concat(#{pre},'%') and char_length(a.pro_no) = 10
查询SQL时查询固定长度的列
最新推荐文章于 2023-03-20 16:48:04 发布
查询pro_no长度为10
select ifnull(max(a.pro_no),0) as maxIndex from t_config_lib a where a.pro_no like concat(#{pre},'%') and char_length(a.pro_no) = 10