SQL - Equal to (=) Operator

The SQL = (equal to) operator checks if the value of left operand is equal to the value of right operand and returns true if the condition is true, false otherwise.

Note: The = operator is also used to assign value (for example assigning values with UPDATE statement).

Syntax

The syntax for using equal to operator is given below:

expression = expression  

Parameters

Example 1:

The example below shows the usage of equal to operator:

SELECT 10 = 10;
Result: 1

SELECT 10.0 = 10;
Result: 1

SELECT 10 = 20;
Result: 0

SELECT 'abc' = 'abc';
Result: 1

SELECT 'abc' = 'xyz';
Result: 0

Example 2:

Consider a database table called Employee with the following records:

To select records of table where Age of the person is equal to 28, the query is given below.

SELECT * FROM Employee
WHERE Age = 28;

The query will produce following result: