Consulta campo varchar

[huesos52]

Código MySQL:

mysql> select *from texto;
+---------+
| campo   |
+---------+
| daniel  |
| daniela |
| 4521369 |
| 45899   |
+---------+
4 rows in set (0.00 sec)
 
mysql> select *from texto where campo REGEXP ('^[0-9]+$') ;
+---------+
| campo   |
+---------+
| 4521369 |
| 45899   |
+---------+
2 rows in set (0.03 sec)
 

saludos