MySQL - 仅从 varchar 列中选择数值

Question

考虑下表:

create table mixedvalues (value varchar(50));

insert into mixedvalues values 
('100'),
('ABC100'),
('200'),
('ABC200'),
('300'),
('ABC300'),
('400'),
('ABC400'),
('500'),
('ABC500');

我如何编写一个只返回数字值的选择语句

100
200
300
400
500

SQLFiddle

Answer 1

SELECT * 
FROM mixedvalues 
WHERE value REGEXP '^[0-9]+$';