MySQL Operators: Types, Examples, and Usage Guide

Operators in MySQL are used to perform operations on data. They are essential in queries for performing calculations, comparisons, logical operations, and more.

MySQL Arithmetic Operators

Operator	Description	Example
+	Addition	Tryit yourself
-	Subtraction	Tryit yourself
*	Multiplication	Tryit yourself
/	Division	Tryit yourself
%	Modulus (Remainder)	Tryit yourself

MySQL Bitwise Operators

Operator	Description
&	Bitwise AND
\|	Bitwise OR
^	Bitwise XOR

MySQL Comparison Operators

Operator	Description	Example
=	Equal to	Tryit yourself
!=	Not equal to	Tryit yourself
<	Less than	Tryit yourself
>	Greater than	Tryit yourself
<=	Less than or equal to	Tryit yourself
>=	Greater than or equal to	Tryit yourself

MySQL Compound Operators

Operator	Description
+=	Add and assign
-=	Subtract and assign
*=	Multiply and assign
/=	Divide and assign
%=	Modulus and assign (Remainder)

MySQL Logical Operators

Operator	Description	Example
AND	Returns `TRUE` if both conditions are true	Tryit yourself
OR	Returns `TRUE` if at least one condition is true	Tryit yourself
NOT	Reverses the result of a condition	Tryit yourself

❮ Previous

Next ❯

Whereisstuff is simple learing platform for beginer to advance level to improve there skills in technologies.we will provide all material free of cost.you can write a code in runkit workspace and we provide some extrac features also, you agree to have read and accepted our terms of use, cookie and privacy policy.