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