WHERE Clause in SQL
WHERE clause is used with the SELECT keyword. ' Where' is a clause which is used for searching the data
with a particular
condition.
If the data in the table matches condition then it returns the specific
value of that particular data.
Syntax
SELECT column FROM table WHERE column operator value |
The following operators can be used:
| Operator | Description |
| = | Equal |
| BETWEEN | Between an inclusive range |
| LIKE |
Search for a pattern |
| IN | If you know the exact value you want to return for at least one of the columns |
WHERE in SQL:
we add a WHERE to the SELECT statement:
SELECT * FROM Persons WHERE unit='india' |