When I use square brackets with a % wildcard as below MySQL does not select any records starting with a number. Many examples across the internet state this as the correct use. Any suggestions? It doesn't work for a letter (a-d) range either. I'm running MySQL 3.2
SELECT * FROM customers WHERE lname LIKE '[0-9]%' ORDER BY lname ASC
or
SELECT * FROM customers WHERE lname LIKE '[a-d]%' ORDER BY lname ASC