How to check if a variable is numeric in MySQL

[Javin Paul]

Hi,

I have a column which is String but suppose to contain numeric Strings. Since it is String their is no constraints to not allow anything else then number. Now I need to get data from this column and has to convert it to number. To avoid any error, I am thinking to first check if String contains only number and then convert. Can anyone please advise how we can do it in MySQL.

Thanks