Select all entry beggining with any number?

[lukep11a]

Hi, I currently have this code that selects all names from the table that begin with the letter 'A', does anybody know how to select all entries from the table that begin with a number?

 

$query = "SELECT * FROM table WHERE name LIKE 'A%'

 

Any help would be very much appreciated.

[harristweed]

Well I guess:

$query = "SELECT * FROM table WHERE name LIKE '1%' OR name LIKE '2%'  name LIKE '3%' name LIKE '4%'................."

will do it!

[lukep11a]

Thanks mate... that worked!

[fortnox007]

I am not sure if this works, but I would rather use some regex instead of repeating 10 likes in 1 query.

 

Maybe try this out:

 

$query = "SELECT * FROM table WHERE name REGEXP '^[0-9]'";

 

for some more insight check this out : http://dev.mysql.com/doc/refman/5.0/en/regexp.html

[Pikachu2000]

SELECT * FROM table WHERE name REGEXP '^[0-9]' isn't a valid SQL statement.

[Psycho]

SELECT * FROM table WHERE name REGEXP '^[0-9]' isn't a valid SQL statement.

 

Sure it is. If you received an error you might want to check which version of MySQL you are using. REGEXP was apparently introduced with ver. 5.1. Of course this assumes that you don't literally have a table named "table". If you do,then you need to enclose the table name in backquotes.

SELECT *
FROM `table`
WHERE name REGEXP '^[0-9]'

[Pikachu2000]

Just looked again and the reason it returned an error was the closing single quote around the pattern was truncated, so you're right. It was my fault for a bad copy/paste it seems.