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 SELECT and 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 count() and 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:

• Operators

• Control flow functions

• String functions

• Numeric functions

• Date and time functions ...

Get MySQL Tutorial now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.