SQL (Structured Query Language) is a powerful language used for managing and manipulating relational databases. It provides a standardized language for querying the databases which are found to be structured, allowing users to define, manipulate, and control the data retrieval with ease. SQL operates through a variety of commands and operators that facilitate some of the most important tasks that are listed below:

• Data retrieval
• Insertion
• Updating
• Deletion

To perform these operations, learning about the operators that are used in them is crucial. Having an in-depth knowledge of the operators and their syntax allows us to write much more efficient queries.

MySQL NOT EQUAL Operator

In MySQL, the NOT EQUAL operator is used to compare two expressions to determine if they are not equal. This operator is primarily used for filtering results in queries to exclude specific values or find records that differ from a given value. Efficient use of the NOT EQUAL operator can significantly enhance your ability to manipulate and retrieve data from a MySQL database.

In MySQL, there are two ways to express the NOT EQUAL operator:

• Using the != operator

• Using the <> operator

Both operators function identically and can be used interchangeably.

Syntax:

SELECT column_name(s)
FROM table_name
WHERE column_name != value;

-- or

SELECT column_name(s)
FROM table_name
WHERE column_name <> value;

Parameters:

• column_name is the column you want to compare.
• value is the value you want to compare against.

Let’s understand the working of a NOT EQUAL operator by working with a live example.

Example of MySQL NOT EQUAL Operator

Creatin the employees table:

-- Create the employees table
CREATE TABLE employees (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    department VARCHAR(50),
    salary INT
);

-- Insert data into the employees table
INSERT INTO employees (id, name, department, salary) VALUES
(1, 'John Doe', 'HR', 50000),
(2, 'Jane Smith', 'IT', 60000),
(3, 'Sam Brown', 'IT', 70000),
(4, 'Lucy Black', 'Finance', 80000),
(5, 'Mark White', 'HR', 55000);

Output:

Employees Table

1. Using != Operator

To find all employees who do not work in the IT department, you can use the following query:

SELECT name, department
FROM employees
WHERE department != 'IT';

Output:

SELECT name, salary
FROM employees
WHERE salary <> 60000;