Searching MySQL

[Anon]

I know how to search through a MySQL DB using the "%" wildcard... But what is the wildcard for numbers? I was to select all the records who's names start with any number... but for the life of me, I can't figure out what the wildcard is... Any help would be appreciated.

[mwilson]

Why not use a regular expression? If you've never used these perhaps a visit to either the MySQL website (http://www.mysql.com) or the PHP website (http://www.php.net) is needed? In short, try this;

SELECT [field] FROM [table] WHERE [field2] REGEXP("^[0-9]");

Says select [field] from [table] where [field2] starts with a number, the ^ means beginning of the line, [0-9] selects any number from 0 to 9 - providing the search you need.

HTH

Matt