MySQL Search First Character is numeric?
How would I select all records where the name column starts with a number for example a table with the following:
303main
ad
jack
435 man
44 something
The query would select:
303main
435 man
44 something
because they start with a number. Any query that will do this? Thanks.
Re: MySQL Search First Character is numeric?
Probably a better way to do it, but this might work:
PHP Code:
select fields from table where left(field, 1) in('0', '1', '2', '3', '4', '5', '6', '7', '8', '9')
Good luck; :)
