IS_NUMERIC ?
| From: | Dwight Altman | Date: | Mon, 28 Nov 2005 16:01:26 +0000 |
| Subject: | IS_NUMERIC ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-40732@lists.php.net to get a copy of this message | ||
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:
1234
1235
1236
1237
I should be able to do it in 1 SQL query if there is an IS_NUMERIC
equivalent, or else I will probably write a PHP script.
Regards,
Dwight