MYSQL怎么根据一个数据区间表对数据进行区间划分

SELECT t.id, t.pro, t.createdate, (SELECT cost FROM t_cost x WHERE x.upd_date = (SELECT max(x2.upd_date) FROM t_cost x2 WHERE t.createdate >= x2.upd_dateand x2.pro = t.pro) and x.pro = t.pro) FROM t_order t

方法1

select * from tableName where progress between 0 and 80

方法2

select * from tableName where cast(substring(progress,1,length(progress)-1) as signed) between 0 and 80

---