Filtering Rows with WHERE Clause in MySQL

Example

SELECT * FROM employees WHERE salary > 50000;

WHERE works with all DML operations to refine your target dataset.