WHERE clause MYSQL
The WHERE clause is used to filter records.
The WHERE clause is used to extract only those records that fulfill a specified condition.
It is used to fetch data based on the conditions.
WHERE is followed by a condition that returns either true or false.
SELECT column1, column2, …
SELECT * FROM employees where emp_no=10185
SELECT * FROM employees where last_name='sidhu'
As you see we have fetched all employee’s with last name ‘sidhu’
Tester Usage Tips:
- Filter records based on condition and validate the records