CODE EXAMPLE FOR SQL

string to int mysql

SELECT field,CONVERT(field,UNSIGNED INTEGER) AS num
FROM table;