The WHERE clause is used to find only records that fulfill a specified criteria.
Where Syntax:-
Select * from table name where city='city name'
Example Table:-
| ID | Name | Class | Roll No |
| 1 | Jai | B.A | 12 |
| 2 | Mohan | M.A | 23 |
| 4 | Om | B.A | 2 |
Select * from example where class='B.A'
Result:-
| ID | Name | Class | Roll No |
| 1 | Jai | B.A | 12 |
| 4 | Om | B.A | 2 |