Select integer values only from a Varchar Field

[mjahkoh]

I have a table with a varchar field. The field has integers and alphanumerics. Is there a way to select numbers only

[Zane]

I'm not sure if there's a way to query it such a way to do that....but

if you just take the data out as is...

 

you can strip the letters out like this (If of course, there are ONLY letter and numbers)

 

$numbers = (int)implode(preg_split("/[^A-Za-z]/", $mysqlRow, -1, PREG_SPLIT_NO_EMPTY);

[Barand]

You could use MySQL built in REGEXP function

 

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