Does NOT EQUAL exist in MySQL?

Yes, NOT EQUAL exists in MySQL in the form of the operator. The syntax is as follows -

SELECT * FROM yourTableName WHERE yourColumnName <> yourValue;

To understand the above syntax, let us create a table. The query to create the table is as follows -

mysql> create table DoesNotEqualDemo
   -> (
   -> Id int NOT NULL AUTO_INCREMENT,
   -> Name varchar(20),
   -> PRIMARY KEY(Id)
   -> );
Query OK, 0 rows affected (0.98 sec)

Use the insert command to insert some records in the table. The query to insert records is as follows -

mysql> insert into DoesNotEqualDemo(Name) values(NULL);
Query OK, 1 row affected (0.24 sec)

mysql> insert into DoesNotEqualDemo(Name) values('John');
Query OK, 1 row affected (0.18 sec)

mysql> insert into DoesNotEqualDemo(Name) values('Carol');
Query OK, 1 row affected (0.43 sec)

mysql> insert into DoesNotEqualDemo(Name) values('Bob');
Query OK, 1 row affected (0.13 sec)

mysql> insert into DoesNotEqualDemo(Name) values('');
Query OK, 1 row affected (0.13 sec)

mysql> insert into DoesNotEqualDemo(Name) values('Larry');
Query OK, 1 row affected (0.13 sec)

mysql> insert into DoesNotEqualDemo(Name) values(NULL);
Query OK, 1 row affected (0.10 sec)

Use the select statement to display all records in the table. The query is as follows-

mysql> select *from DoesNotEqualDemo;

The following is the output-

+----+-------+
| Id | Name  |
+----+-------+
|  1 | NULL  |
|  2 | John  |
|  3 | Carol |
|  4 | Bob   |
|  5 |       |
|  6 | Larry |
|  7 | NULL  |
+----+-------+
7 rows in set (0.00 sec)

Here is the query to select all records that are not equal to NULL and empty string-

mysql> select *from DoesNotEqualDemo where Name <> &#39;NULL&#39; and Name <> &#39;&#39;;

The following is the output-

+----+-------+
| Id | Name  |
+----+-------+
|  2 | John  |
|  3 | Carol |
|  4 | Bob   |
|  6 | Larry |
+----+-------+
4 rows in set (0.00 sec)

The above is the detailed content of Does NOT EQUAL exist in MySQL?. For more information, please follow other related articles on the PHP Chinese website!