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