MySQL, 5th Edition

C. Operator and Function Reference

This appendix lists the operators and functions used to construct expressions in SQL statements. Unless otherwise indicated, each has been present in MySQL at least as early as MySQL 5.5.0. Changes since MySQL 5.5.0 are indicated in the descriptions for individual operators and functions.

Most operator and function examples use the following format:

expr                                              → result

The expression expr demonstrates how to use an operator or function, and result shows the value that results from evaluating the expression. For example:

RIGHT('my cat',3)                                 → 'cat'

This means that the function call RIGHT('my cat',3) produces the string result 'cat'. To try an ...