C. Operator and Function Reference

This appendix lists the operators and functions you can use to construct expressions in SQL statements. Changes in behavior since 5.0.0 are indicated in the descriptions for individual operators and functions.

Operator and function examples are written in the following format:

image

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

image

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

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.