Built-In Function and Operator Reference SQL Modes” .) Individual client programs can request this behavior by using the CLIENT_IGNORE_SPACE  option for  mysql_real_connect() . In either case, all function names become reserved words. For the sake of brevity, some examples in this chapter display the output from the  mysql  program in abbreviated form. Rather than showing examples in this format: mysql>  SELECT MOD(29,9); +-----------+ | mod(29,9) | +-----------+ | 2 | +-----------+ 1 rows in set (0.00 sec) mysql>  SELECT MOD(29,9); -> 2 This format is used instead: 12.1 Built-In Function and Operator Reference The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference” . Table 12.1 Built-In Functions and Operators Name Description Introduced Deprecated & Bitwise AND > Greater than operator >> Right shift >= Greater than or equal operator < Less than operator <> ,  != Not equal operator << Left shift <= Less than or equal operator <=> NULL-safe equal to operator % ,  MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). 2095