Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Write down the MySQL query which shows equality condition?
The binary equality operators compare their operands for strict equality or inequality. In MySQL, the equal-to-operator (=) returns 1 if both the operands have the same value otherwise returns 0. Following MySQL query show an equality condition −
mysql> Select tender_value From estimated_cost WHERE id = 3;
The above query shows an equality condition because the column id equates to the integer value.
mysql> Select tender_value From estimated_cost1 WHERE Name_company = 'Chd Ltd.';
The above query shows an equality condition because column Name_company equates to the string value.
Updated on: 22-Jun-2020
58 Views
Advertisements