How To Select Only Numeric Values From MySQL

Author: erics, Posted September 6th, 2012 at 6:32:36pm

select field from table where field REGEXP '^-?[0-9]+$';

1	select field from table where field REGEXP '^-?[0-9]+$';

All fields marked with "*" are required.