#### 3.3.4.3 選擇指定列 如果你不想看到表中的所有行, 只需要用逗號分隔感興趣的列. 例如, 如果你想知道你的動物是什么是時候出生的, 選擇 `name` 和 `birth` 列: ```sql mysql> SELECT name, birth FROM pet; +----------+------------+ | name | birth | +----------+------------+ | Fluffy | 1993-02-04 | | Claws | 1994-03-17 | | Buffy | 1989-05-13 | | Fang | 1990-08-27 | | Bowser | 1989-08-31 | | Chirpy | 1998-09-11 | | Whistler | 1997-12-09 | | Slim | 1996-04-29 | | Puffball | 1999-03-30 | +----------+------------+ ``` 要了解誰擁有寵物, 使用以下查詢: ```sql mysql> SELECT owner FROM pet; +--------+ | owner | +--------+ | Harold | | Gwen | | Harold | | Benny | | Diane | | Gwen | | Gwen | | Benny | | Diane | +--------+ ``` 注意, 查詢只是從每條記錄中檢索 `owner` 列, 其中某些記錄不止出現一次. 要最小化輸出, 只徐通過添加 `DISTINCT` 關鍵詞一次檢索處每個唯一的輸出記錄: ```sql mysql> SELECT DISTINCT owner FROM pet; +--------+ | owner | +--------+ | Benny | | Diane | | Gwen | | Harold | +--------+ ``` 你可以使用 `WHERE` 子句組合記錄選擇和列選擇. 例如, 僅僅獲取貓狗的出生日期, 使用以下查詢: ```sql mysql> SELECT name, species, birth FROM pet WHERE species = 'dog' OR species = 'cat'; +--------+---------+------------+ | name | species | birth | +--------+---------+------------+ | Fluffy | cat | 1993-02-04 | | Claws | cat | 1994-03-17 | | Buffy | dog | 1989-05-13 | | Fang | dog | 1990-08-27 | | Bowser | dog | 1989-08-31 | +--------+---------+------------+ ```