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:
expr → result
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'. You can try the examples shown in this appendix for yourself using the
mysql program. To try the preceding example, invoke the
mysql program, type in the example ...