Omega Omega - 1 year ago 77
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 Source
SELECT * FROM YourTable WHERE YourColumn regexp '^[0-9]+'