MySQL – Select only numeric values from varchar column

December 7, 2023 by Tarik

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