Definition: In SQL where is used with select to choose specifically what to search for in your MySQL database.
Examples:
SELECT * FROM Pets WHERE Pet_type = "Cats";