SQL operators are symbols and keywords that are used to compare data.

They are commonly used in the WHERE clause of a query.

If you’ve learnt about the WHERE clause (which is used to filter your results to match a criteria), you would have learnt a little about operators.

The equals sign = is an operator, which means “is equal to”. When used in a where clause, it says “where some_expression is equal to another_expression”.

So, they help you compare data. They are often used in the WHERE clause but can be used in other places such as the HAVING clause and joins.