The WHERE clause in MySQL is used in conjunction with the "SELECT", "UPDATE", "DELETE", and other SQL statements to filter rows based on specified conditions.
It allows us to "retrieve", "update", or "delete" only those rows that meet the specified criteria.
SELECT column1, column2, ... FROM table_name WHERE condition;
column1, column2, ...: The columns we want to retrieve from the table. We can use an asterisk (*) to select all columns.
table_name: The name of the table from which we want to retrieve data.
WHERE condition: The condition that specifies which rows to include in the result set.
SELECT * FROM products WHERE category = 'GAMES';
SELECT * FROM products WHERE price > 100;