Get MySQL results where the first letter is numeric:

SELECT * FROM table WHERE (LEFT(columnname,1) REGEXP '[0-9]')

Or get MySQL results where the first letter is alpha:

SELECT * FROM table WHERE (LEFT(columnname,1) REGEXP '[a-z]')

Tags: mysql, regexp