8.Using MySQL Built-In Functions with SELECT
MySQL has a wide variety of built-in operators and functions that can be useful for writing queries. Most of these are for use in the
WHERE clauses. There are also some special grouping functions for use in the
GROUP BY clause. We have already used the basic comparison operators and the
max() functions. A vast number of functions are available. In this chapter, we take a tour of the most useful ones. This book is not trying to be a function reference by any means—we are just trying to give you a feel for the types of functionality available.
We will cover the following:
• Control flow functions
• String functions
• Numeric functions
• Date and time functions ...