MySQL Operators

MySQL Arithmetic Operators

Operator	Description	Example
+	Add	Try it
-	Subtract	Try it
*	Multiply	Try it
/	Divide	Try it
%	Modulo	Try it

Practice Excercise Practice now

MySQL Bitwise Operators

Operator	Description
&	Bitwise AND
|	Bitwise OR
^	Bitwise exclusive OR

Practice Excercise Practice now

MySQL Compound Operators

Operator	Description
+=	Add equals
-=	Subtract equals
*=	Multiply equals
/=	Divide equals
%=	Modulo equals
&=	Bitwise AND equals
^-=	Bitwise exclusive equals
|*=	Bitwise OR equals

Practice Excercise Practice now

MySQL Logical Operators

Operator	Description	Example
ALL	TRUE if all of the subquery values meet the condition	Try it
AND	TRUE if all the conditions separated by AND is TRUE	Try it
ANY	TRUE if any of the subquery values meet the condition	Try it
BETWEEN	TRUE if the operand is within the range of comparisons	Try it
EXISTS	TRUE if the subquery returns one or more records	Try it
IN	TRUE if the operand is equal to one of a list of expressions	Try it
LIKE	TRUE if the operand matches a pattern	Try it
NOT	Displays a record if the condition(s) is NOT TRUE	Try it
OR	TRUE if any of the conditions separated by OR is TRUE	Try it
SOME	TRUE if any of the subquery values meet the condition	Try it

Practice Excercise Practice now