infomf infomf - 4 months ago 42
MySQL Question

MySql type char select max number

how select max or min number from colums of type char?

Function max return max lenght.



Just add zero in your coloum

select max(column+0),min(column+0)  

By adding zero to a column mysql cast coloum to integer