# 1.2.3.4.Using LIKE and WILDCARDS

* 查詢字串中含有某關鍵字的資料
  *   %: 可以表示多個未知字元

      ```
      select * from StudentsDetails where firstname like 'student%';
      ```

      ![](https://1088158622-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4M0G87SQJ28mvsXOhL%2F-M4M0IBPb1goOGpuG1BI%2F-M4M0LhbihwCTbP1Gusq%2F2018041422.jpg?generation=1586302926563381\&alt=media)
  *   \_: 可以表示一個未知字元

      ```
      select * from StudentsDetails where firstname like 'student_';
      ```

      ![](https://1088158622-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4M0G87SQJ28mvsXOhL%2F-M4M0IBPb1goOGpuG1BI%2F-M4M0LhdiSIN5oI5CUDa%2F2018041424.jpg?generation=1586302926789751\&alt=media)
