RE: [PHP-DB] IS_NUMERIC ?

2005-11-28 Thread Bastien Koert
REGEXP? Bastien From: "Dwight Altman" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] IS_NUMERIC ? Date: Mon, 28 Nov 2005 10:01:26 -0600 Hello List, Is there an IS_NUMERIC(aCandidateString) function in MySQL that I can run in a query, similar to the various PHP "is_*"

[PHP-DB] IS_NUMERIC ?

2005-11-28 Thread Dwight Altman
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 ..