Write a MySQL query that shows an inequality condition?

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!