Operator

Operator : Operator : Introduction MySQL TUTORIALS

Name	Description
AND, &&	Logical AND
BINARY	Cast a string to a binary string
&	Bitwise AND
\|	Bitwise OR
^	Bitwise XOR
/	Division operator
DIV	Integer division
	NULL-safe equal to operator
=	Equal operator
>=	Greater than or equal operator
>	Greater than operator
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
%	Modulo operator
!=,	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
~	Invert bits
*	Times operator
-	Change the sign of the argument
XOR	Logical XOR