I want to get the max(id) from a table colum with variable characters. it always returns 999 as the highest yet I have values like 6008 or even over 10000. I have tried the following:
SELECT Max(column_name) from table_name where column_name REGEXP '^[0-9]+$'
isNumeric as one of the conditions but mysql says function ..isnumeric does not exist.
How can I get the correct maxmum integer value from a column with varchar values?