mysql convert string to number in select code example Example: mysql parse int SELECT CAST(PROD_CODE AS INT) FROM PRODUCT