# 查詢表里符合特定搜索條件的數據 當要查詢滿足特定搜索條件的數據時，給 SELECT 查詢語句增加一個 WHERE 子句即可。SQL 語句格式如下： ~~~ SELECT select_list FROM table_list WHERE query_condition ~~~ 查詢 2 號倉庫第 5 區的訂單，SQL 語句如下： ~~~ SELECT * FROM ordr WHERE o_w_id=2 and o_d_id=5 ; ~~~ 執行結果如下： ~~~ +--------+--------+------+--------+--------------+----------+-------------+------------+ | o_w_id | o_d_id | o_id | o_c_id | o_carrier_id | o_ol_cnt | o_all_local | o_entry_d | +--------+--------+------+--------+--------------+----------+-------------+------------+ | 2 | 5 | 2100 | 2100 | 5 | 12 | 1 | 2020-02-15 | | 2 | 5 | 2101 | 4 | NULL | 11 | 1 | 2020-02-15 | | 2 | 5 | 2102 | 440 | NULL | 7 | 1 | 2020-02-15 | +--------+--------+------+--------+--------------+----------+-------------+------------+ 3 rows in set (0.01 sec) ~~~