Omega Omega - 10 months ago 53
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?

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