create table if not exists t_flttst (recid int unsigned
 not null primary key, numflt float);
delete from t_flttst;
insert into t_flttst (recid, numflt) values (0,123);
insert into t_flttst (recid, numflt) values (1,123.25);
insert into t_flttst (recid, numflt) values (2,1.25);
insert into t_flttst (recid, numflt) values (3,1.0250);
insert into t_flttst (recid, numflt) values (4,0.250);
insert into t_flttst (recid, numflt) values (5,1.240);
insert into t_flttst (recid, numflt) values (6,1.230);
insert into t_flttst (recid, numflt) values (7,1.220);
select * from t_flttst;
select * from t_flttst where numflt = 123 \p;
select * from t_flttst where numflt = 1.25 \p;
select * from t_flttst where numflt = 1.250 \p;
select * from t_flttst where numflt = 1.025 \p;
select * from t_flttst where numflt = 1.0250 \p;
select * from t_flttst where numflt = 0.25 \p;
select * from t_flttst where numflt = 0.250 \p;
select * from t_flttst where numflt = 0.24 \p;
select * from t_flttst where numflt = 0.23 \p;
select * from t_flttst where numflt = 0.22 \p;
