[Klesti]

Hi
I have writen a music library script but i don't know how to select from the mysql database all entries of the table artist (the field artist is used as WHERE clause) that begin with a number.

Help?

[ben.periton]

Perhaps the LIKE command will help
Have a look at http://www.htmlite.com/mysql011.php

[Sabu]

Tat's only really good if you know the specific number at the start.

perhaps RLIKE could be your new friend

[moronovich]

you can set the query like this:

PHP Code:

$query = "SELECT * FROM `artistTable` WHERE `artistName` REGEXP '^[0-9]'";

mysql_query($query);