Where condition in SQL
The MySQL WHERE statement is used to define a circumstance when the data is collected from a separate list or joined to several tables. If the specified circumstance is met, then only the unique value of the table is returned. To extract the information and retrieve only the correct records, you can use the WHERE statement.
Not only, the WHERE condition used in the Selection statement, but it is also used in the UPDATE assertion, DELETE assertion, etc.
Syntax
Now, we have discussed the syntax of the SELECT statement associated with the WHERE condition. It is shown below-
FROM table_name
WHERE {condition}
Note: The WHERE condition is used not only in the Selection assertion but also in the UPDATE assertion, the Remove assertion, etc.!
You may use contrast or logical operators, such as >, <, =, LIKE, NOT, etc. To define a state. The below-given example will explicitly state this notation.
For Example-
Here, we consider the table of CUSTOMERS with the below-given records.
| CustomerID | CustomerName | Address | Age | Salary |
|---|---|---|---|---|
| 001 | Hardy Thompson | Maxico | 25 | 10000.00 |
| 002 | Sturt Broad Los Angeles | 28 | 25000.00 | |
| 003 | Joseph Winget | California | 30 | 56000.00 |
| 004 | David Anderson | Norway | 24 | 76000.00 |
| 005 | Alexa | Denmark | 35 | 23000.00 |
Now, we will run the below-given query on SQL to fetch the CustomerID, CustomerName and Salary from the above table CUSTOMERS, where the salary is greater than 25000.
from CUSTOMERS
Where Salary > 25000;
Output
After the successful execution of the above SQL query, we got the following output.
Here, we have another instance where we would get the CustomerID, CustomerName and Salary from the database table named CUSTOMERS for a specific customer named Joseph Winget.
from CUSTOMERS
Where CustomerName = 'Joseph Winget';
Output
After the successful execution of the above SQL query, we got the above-given outcome.
