infomf infomf - 1 year ago 105
MySQL Question

MySql type char select max number

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

Function max return max lenght.


Answer Source

Just add zero in your coloum

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

By adding zero to a column mysql cast coloum to integer

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download