>  -----Original Message-----
>  From: El Bekko [mailto:elbekko@[...].com] 
>  
>  http://php.belnet.be/manual/en/function.is-numeric.php
>  
>  Apparently there is :)
>  
>  
>  Dwight Altman wrote:
>  > Hello List,
>  > Is there an IS_NUMERIC(aCandidateString) function in MySQL that I
can run in
>  > a query, similar to the various PHP "is_*" functions?  I can't seem
to find
>  > it in the docs (other than a C API IS_NUM macro).
>  > 
>  > I have a field in a database with serial numbers like:
>  > ...1234
>  > ...1235
>  > ...1236-A
>  > ...1237B
>  > and I want to get the last 4 characters of the numeric substring
like so:
[snip]

Last I checked, MySQL doesn't support PHP functions natively :)

His question was whether there's an equivalent function to that in
MySQL, and I agree with a previous answer, you can use a REGEXP (
http://dev.mysql.com/doc/refman/4.1/en/regexp.html ) if there is nothing
else available.

(example - randomly scrounged together)
REGEXP '^.*[:digit:]{4}.[^:digit:]*$'    ( {1,4} if you want the last
group of up to 4 digits)

cheers,
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257

The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php