
上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.