cast or convert from varchar to integer in mysql

 select convert(id, UNSIGNed integer) as id from tb_test order by id  
 select CAST(id AS UNSIGNED) as id from tb_test order by id  

Comments

Popular posts from this blog

Data Flow Diagram (DFD)

allow only numeric (0-9) in html inputbox using jquery