MySQL Operators

Last Updated: 04 July, 2023

In MySQL, operators are special symbols or keywords used to perform various operations on data within queries or statements. These operators are used in conjunction with SQL statements to filter, manipulate, and perform calculations on data in databases.

Here are some commonly used MySQL operators:

Arithmetic Operators:

• +     :   Addition
• -      :   Subtraction
• *      :   Multiplication
• /      :   Division
• %     :   Modulus (remainder)

Comparison Operators:

• = : Equal to
• <> or !=: Not equal to
• <: Less than
• >: Greater than
• <=: Less than or equal to
• >=: Greater than or equal to

Logical Operators:

• AND : Logical AND
• OR : Logical OR
• NOT : Logical NOT (negation)

BETWEEN Operator:

BETWEEN: Used to check if a value lies within a specified range.

IN Operator:

IN: Used to check if a value matches any value in a list.

LIKE Operator:

LIKE: Used for pattern matching in string values, using wildcard characters (% for any number of characters and _ for a single character).

NOT LIKE Operator:

NOT LIKE: Used to check if a string does not match a specified pattern.

IS NULL Operator:

IS NULL: Used to check if a value is NULL.

IS NOT NULL Operator:

IS NOT NULL: Used to check if a value is not NULL.

EXISTS Operator:

EXISTS: Used to check if a subquery returns any rows.

These operators can be used in SELECT, WHERE, HAVING, JOIN, and other clauses to perform data retrieval, filtering, and manipulation operations in MySQL queries. Keep in mind that some operators might have variations or synonyms in different database systems, but the ones listed above are standard in MySQL.