select * from table where (LENGTH(column ) - instr(column , '.') > 2 and instr(column , '.') > 0
instr(column , '.') > 0 表示去掉不包含小数点数据
select * from table where (LENGTH(column ) - instr(column , '.') > 2 and instr(column , '.') > 0
instr(column , '.') > 0 表示去掉不包含小数点数据