mysql - Is it possible to use Wildcards for checking with Numerical columns in SQL? -

for example, im using below query , following error correspondingly

select min(amt) trnsact  amt not '0%'; 

here, amt purchase amt , want find out cheapest purchase amount using query above there lot of rows values 0, 0.1 0.02 etc. dont want those. want values less 1 maybe. error is:

error code - 3544 error message - [teradata database] [terajdbc 15.10.00.05] [error 3544] [sqlstate hy000] partial string matching requires character operands.

please guys!!!

simply can use

select min(amt) trnsact amt >= 1;