I have certain names stored in a table, and I want to be able to search the database by letters/numbers. For example, I can list all values that start with A:
SELECT * FROM table WHERE name LIKE 'A%';
How would I go about listing any names that begin with the numbers 0-9? Is there a way to do this with one SELECT statement, or do I need to use a loop? If you need a loop, how would that look? I'm not quite sure how to do that.