12.3 Operators

12.3.1 Operator Precedence
12.3.2 Comparison Functions and Operators
12.3.3 Logical Operators
12.3.4 Assignment Operators

Table 12.2 Operators

NameDescription
`AND`, `&&`Logical AND
`=`Assign a value (as part of a `SET` statement, or as part of the `SET` clause in an `UPDATE` statement)
`:=`Assign a value
`BETWEEN ... AND ...`Check whether a value is within a range of values
`BINARY`Cast a string to a binary string
`&`Bitwise AND
`~`Invert bits
`|`Bitwise OR
`^`Bitwise XOR
`CASE`Case operator
`DIV`Integer division
`/`Division operator
`<=>`NULL-safe equal to operator
`=`Equal operator
`>=`Greater than or equal operator
`>`Greater than operator
`IS NOT NULL`NOT NULL value test
`IS NOT`Test a value against a boolean
`IS NULL`NULL value test
`IS`Test a value against a boolean
`<<`Left shift
`<=`Less than or equal operator
`<`Less than operator
`LIKE`Simple pattern matching
`-`Minus operator
`% or MOD`Modulo operator
`NOT BETWEEN ... AND ...`Check whether a value is not within a range of values
`!=`, `<>`Not equal operator
`NOT LIKE`Negation of simple pattern matching
`NOT REGEXP`Negation of REGEXP
`NOT`, `!`Negates value
`||`, `OR`Logical OR
`+`Addition operator
`REGEXP`Pattern matching using regular expressions
`>>`Right shift
`RLIKE`Synonym for REGEXP
`SOUNDS LIKE`Compare sounds
`*`Multiplication operator
`-`Change the sign of the argument
`XOR`Logical XOR