Omega Omega - 6 months ago 14
MySQL Question

Select values that begin with a number

I have a table with a column containing data that begin with numbers too, on MySQL

How can I select the rows that begin only with a number?

Answer
SELECT * FROM YourTable WHERE YourColumn regexp '^[0-9]+'