Some of the types of operators in MySQL are listed below.

## 1. Arithmetic Operator

**+**= Add**-**= Subtract*****= Multiply**/**= Divide**%**= Modulo

## 2. Bitwise Operator

**&**= Bitwise AND**|**= Bitwise OR**^**= Bitwise Exclusive OR

## 3. Comparison Operator

**=**= Equal To**<**= Less Than**>**= Greater Than**<=**= Less Than Or Equals**>=**= Greater Than Or Equals**<>**= Not Equal To

## 4. Compound Operator

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

## 5. Logical Operator

**ALL**= TRUE if all of subquery values meet the condition**AND**= TRUE if both the provided conditions are satisfied.**ANY**= TRUE if any conditions get satisfied.**BETWEEN**= True if the range provided and the between values are satisfied.**EXISTS**= TRUE if subquery returns one or more records**IN**= TRUE if the operand is equal to one of a list.**LIKE**= TRUE if the operand matches.**NOT**= Displays record if the condition is NOT TRUE**OR**= TRUE if any one of the conditions gets satisfied.**SOME**= TRUE if any of the conditions get satisfied.