MySQL Resources | resources for mysql admins and developers who are squealing for help

quick links

Numeric & Mathematical Functions

These custom functions are related to numeric values or mathematical calculations in general.

IS_NUMERIC

There is not a function explicitly for determining if the value of a field is numeric or not. This customized function will return 1 if a given value is numeric, 0 if not.

Every where I look, I see columns (Dublin, Ireland)

If you work with MySQL regularly and need a book on the topic with an easy to follow writing style and helpful examples, please consider buying MySQL in a Nutshell. If you already have the first edition, the second edition recently came out: it’s much better than the first edition and has had some great reviews. Click on the cover art work here and you’ll be taken to Amazon’s site where you can purchase a copy and have it mailed to you.