Home  >  Article  >  Database  >  Write a MySQL query that shows equality conditions?

Write a MySQL query that shows equality conditions?

PHPz
PHPzforward
2023-09-16 18:29:021217browse

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

#The binary equality operator compares whether its operands are strictly equal or unequal. In MySQL, the equality operator (=) returns 1 if both operands have the same value and 0 otherwise. The following MySQL query shows the equality condition -

mysql> Select tender_value From estimated_cost WHERE id = 3;

The above query shows the equality condition because the column id is equal to the integer value.

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

The above query shows the equality condition because the column Name_company is equal to the string value.

The above is the detailed content of Write a MySQL query that shows equality conditions?. 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