Home  >  Article  >  Database  >  Write a MySQL query that shows an inequality condition?

Write a MySQL query that shows an inequality condition?

PHPz
PHPzforward
2023-09-09 10:01:031136browse

写出显示不等式条件的 MySQL 查询?

Inequality means NOT EQUAL TO. MySQL has two inequality operators, ‘’ and ‘!=’. The following MySQL query shows the inequality condition

mysql> Select tender_value From estimated_cost1 WHERE Name_company != 'Chd Ltd.';

The above query shows the inequality condition because it has the != operator.

mysql> Select tender_value From estimated_cost1 WHERE Name_company <> &#39;Chd Ltd.&#39;;

The above query shows the inequality condition because it has the operator.

The above is the detailed content of Write a MySQL query that shows an inequality condition?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete