O'Reilly logo

MySQL® by Paul DuBois

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix 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:

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'. 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required