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)

VERIFIKASI SUARA MENGGUNAKAN METODE MFCC DAN DTW MENGGUNAKAN METODE MFCC DAN DTW (BAB II TINJAUAN PUSTAKA)

flexigrid + php with add and edit button