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";This would show all data from entries in the table Pets where the Pet_type field contains Cats.
