mysql get integer from string code example Example: mysql parse int SELECT CAST(PROD_CODE AS INT) FROM PRODUCT