MySQL 8 Cookbook

Filter based on condition

Find emp_no of employees with first_name as Georgi and last_name as Facello:

mysql> SELECT emp_no FROM employees WHERE first_name='Georgi' AND last_name='Facello';+--------+| emp_no |+--------+|  10001 ||  55649 |+--------+2 rows in set (0.08 sec)

All the filtering conditions are given through the WHERE clause. Except integers and floating points, everything else should be put inside quotes.