2019-08-05mysql查询小数位

select * from draw_allningbo_20190623_2_01 where lab_value1000 - floor(lab_value1000) > 0