Try this
SELECT Age FROM Ages WHERE (Age REGEXP ('^[0-9]+'));
I havent tried it but it looks like it might work. :)
> Any way in MySQL to select rows where a value is or can be converted to a
> number?
>
> sort of like:
>
> SELECT Age
> FROM Ages
> WHERE IsNumeric(Age)
>
> My best workaround so far seems to be just do the select as normal, then
> loop through the list, removing rows where "NOT IsNumeric(query.Age)".
>
>
> --
> These lists are syncronised with the CFDeveloper forum at
> http://forum.cfdeveloper.co.uk/
> Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> CFDeveloper Sponsors and contributors:-
> *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
> activepdf.com*
> *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
> *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
>
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
