cast varchar to int mysql code example Example: mysql parse int SELECT CAST(PROD_CODE AS INT) FROM PRODUCT