MySQL 8 Cookbook
上QQ阅读APP看书,第一时间看更新

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.