cast as integer mysql code example
Example 1: mysql parse int
SELECT CAST(PROD_CODE AS INT) FROM PRODUCTExample 2: mysql cast to varchar
SELECT CAST(aField as UNSIGNED) from table;
-- for VARCHAR use CHAR(50), INT use UNSIGNEDSELECT CAST(PROD_CODE AS INT) FROM PRODUCTSELECT CAST(aField as UNSIGNED) from table;
-- for VARCHAR use CHAR(50), INT use UNSIGNED