Select 查詢資料表

1. 查詢資料表 tbl 的內容。

   MariaDB root@(none):dyw> select * from tbl;
   +----+---------+--------+-----------------+
   | id | title   | author | submission_date |
   +----+---------+--------+-----------------+
   | 1  | PHP     | david  | 2025-11-10      |
   | 2  | Linux   | linux  | 2025-11-10      |
   | 3  | Mariadb | dywang | 2025-11-11      |
   +----+---------+--------+-----------------+
   
   3 rows in set
   Time: 0.039s
   

2. 查詢資料表 tbl 的內容，且以欄位 title 排序。

   MariaDB root@(none):dyw> select * from tbl order by title;
   +----+---------+--------+-----------------+
   | id | title   | author | submission_date |
   +----+---------+--------+-----------------+
   | 2  | Linux   | linux  | 2025-11-10      |
   | 3  | Mariadb | dywang | 2025-11-11      |
   | 1  | PHP     | david  | 2025-11-10      |
   +----+---------+--------+-----------------+
   
   3 rows in set
   Time: 0.030s
   

3. 查詢資料表 tbl 的內容，限制只列出一筆。

   MariaDB root@(none):dyw> select * from tbl limit 1;
   +----+-------+--------+-----------------+
   | id | title | author | submission_date |
   +----+-------+--------+-----------------+
   | 1  | PHP   | david  | 2025-11-10      |
   +----+-------+--------+-----------------+
   
   1 row in set
   Time: 0.025s
   

4. 查詢資料表 tbl 的內容，限制只列出一筆，且位移一筆。

   MariaDB root@(none):dyw> select * from tbl limit 1 offset 1;
   +----+-------+--------+-----------------+
   | id | title | author | submission_date |
   +----+-------+--------+-----------------+
   | 2  | Linux | linux  | 2025-11-10      |
   +----+-------+--------+-----------------+
   
   1 row in set
   Time: 0.023s
   

5. Where 條件運算子：

   = != > < >= <=
   

6. 查詢 author='dywang' 的紀錄。

   MariaDB root@(none):dyw> select * from tbl where author='dywang';
   +----+---------+--------+-----------------+
   | id | title   | author | submission_date |
   +----+---------+--------+-----------------+
   | 3  | Mariadb | dywang | 2025-11-11      |
   +----+---------+--------+-----------------+
   
   1 row in set
   Time: 0.017s
   

7. 可用 AND 及 OR 結合多個條件。

   MariaDB root@(none):dyw> select * from tbl where author='dywang' or id=1;
   +----+---------+--------+-----------------+
   | id | title   | author | submission_date |
   +----+---------+--------+-----------------+
   | 1  | PHP     | david  | 2025-11-10      |
   | 3  | Mariadb | dywang | 2025-11-11      |
   +----+---------+--------+-----------------+
   
   2 rows in set
   Time: 0.034s
   

8. LIKE 配合 WHERE 使用，只是將等號改成 LIKE 即可，LIKE 後接的字串配合百分比 % 符號，可進行字串搜尋。例如：LIKE d% 表示搜尋 d 開頭的字串。

   MariaDB root@(none):dyw> select * from tbl where author like 'd%';
   +----+---------+--------+-----------------+
   | id | title   | author | submission_date |
   +----+---------+--------+-----------------+
   | 1  | PHP     | david  | 2025-11-10      |
   | 3  | Mariadb | dywang | 2025-11-11      |
   +----+---------+--------+-----------------+
   
   2 rows in set
   Time: 0.016s