Omega Omega - 1 year ago 99
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]+'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download