is_numeric equivilant for MySQL?

[acidbox]

I am wondering if there is a an equivilent is_numeric function for MySQL?

[mrhappiness]

I am wondering if you can explain to me why you need this since you should know your columns' types

But if you really need to store numeric values into varchar or text columns maybe this is of help:

mysql> select 'A' + 0, '45' + 0, 'a4' + 0, '4a' + 0;
+---------+----------+----------+----------+
| 'A' + 0 | '45' + 0 | 'a4' + 0 | '4a' + 0 |
+---------+----------+----------+----------+
|       0 |       45 |        0 |        4 |
+---------+----------+----------+----------+

[acidbox]

I'm importing data from a different database and the fields are all screwed up and Im just trying to brute force determine what is wrong with it.