[Resolved] regexp 0-9

[tuf-web_co_uk]

hey, i'm trying to select all the records from a table which have a certain field starting with a number

from previous help i built this piece of code but it returns everything from my table

<?
include("includes/auth/common.php");

$sql = "SELECT * FROM `polyphonics` WHERE `name` REGEXP '^[0-9]*'";
$query = mysql_query($sql) or die (mysql_error());

while ($row=mysql_fetch_array($query)) {

echo $row['name']."<br>";	

}

?>

any help would be great

thanks 🙂

[LordShryku]

The on the end is what's hurting you
Using either
REGEXP '^[0-9].'
or
REGEXP '^[0-9]'
would work

[tuf-web_co_uk]

thanks!

resolved - tick 😉