LIKE '[0-9]%' 1

[Triion]

Hi,

I want to make a catalog, in which the user can search by the startingletter of the game, A through Z, which is easy with "WHERE column LIKE '$letter%'" where $letter is PHP for the letter the user has chosen.

But There are games that start with a number... I'd like to make a query that gives the games that start with a number [0-9], but I have no idea how...
Is there a way to add a regular expression in the LIKE-clause?

How would you solve this?

Thanx in advance,
Triion

 

[TonyGroves]

You can use the REGEXP (or RLIKE, which is identical) operator:
[tt]
WHERE column REGEXP '^[0-9]'
[/tt]
REGEXP uses a different syntax to LIKE. The syntax is explained in the MySQL manual.