How do you select values from MySQL that only start with numbers

[kpetsche20]

How do you select values from a MySQL database that only start with numbers

[ratcateme]

i think you need to retrieve all values then you could use php like this

if(is_numeric(substr($row['field'],0,1))){
//starts with a number
}

 

Scott.

[kenrbnsn]

I would use the mysql substr() function:

<?php
$q = "select somefield from table where substr(somefield,1,1) in '0,1,2,3,4,5,6,7,8,9';
?>

 

Note: untested.

 

Ken