12.4 Operators

12.4.1 Operator Precedence

12.4.2 Comparison Functions and Operators

12.4.3 Logical Operators

12.4.4 Assignment Operators

Table 12.3 Operators

Name	Description	Introduced
&	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().
->>	Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()).	5.7.13
/	Division operator
:=	Assign a value
=	Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement)
=	Equal operator
^	Bitwise XOR
AND, &&	Logical AND
BETWEEN ... AND ...	Whether a value is within a range of values
BINARY	Cast a string to a binary string
CASE	Case operator
DIV	Integer division
EXISTS()	Whether the result of a query contains any rows
IN()	Whether a value is within a set of values
IS	Test a value against a boolean
IS NOT	Test a value against a boolean
IS NOT NULL	NOT NULL value test
IS NULL	NULL value test
LIKE	Simple pattern matching
NOT, !	Negates value
NOT BETWEEN ... AND ...	Whether a value is not within a range of values
NOT EXISTS()	Whether the result of a query contains no rows
NOT IN()	Whether a value is not within a set of values
NOT LIKE	Negation of simple pattern matching
NOT REGEXP	Negation of REGEXP
OR, ||	Logical OR
REGEXP	Whether string matches regular expression
RLIKE	Whether string matches regular expression
SOUNDS LIKE	Compare sounds
XOR	Logical XOR
|	Bitwise OR
~	Bitwise inversion