SQL LIKE problem using PHP and MySQL

[Terminator3d]

Hi guys!

Could really do with some help on this one. Im trying write a query to search for anything that starts with a number, and has any other characters following. It sounds easy I know but its driving me crazy.

Ive got the following atm:
SELECT DVDname, Director FROM DVD WHERE DVDname LIKE '[0-9]%' ORDER BY DVDname;

Can anyone see what im doing wrong please? Im using PHP4 with MySql5.

Thanks.

 

[Haircut]

I think you need the REGEXP keyword if you're trying to match based on a regular expression.

http://dev.mysql.com/doc/refman/4.1/en/regexp.html

 

[Terminator3d]

Thanks for that. Managed to get it sorted. Solution was the following, just in case anyone else gets the problem:

SELECT DVDname, Director FROM DVD WHERE DVDname REGEXP '[0-9].*' ORDER BY DVDname;