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)

flexigrid + php with add and edit button

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