In this short note, Listed some quick relevant WHERE Clause keywords and methods which will use in SQL query.

WHERE clause is used to add condition(s), so it returns data satisfying provided condition.

SELECT lastname, firstname, title FROM employee WHERE …