MySQL中BETWEEN子句的用法實例詳解

這篇文章主要介紹了中between子句的用法詳解,是學習中的基礎知識,需要的朋友可以參考下

可以使用IN子句來代替相結合的“大于等于和小于等于”的條件。

要了解BETWEEN 子句考慮的EMPLOYEE_TBL表有以下記錄:

mysql>?SELECT?*?FROM?employee_tbl;  +------+------+------------+--------------------+  |?id??|?name?|?work_date?|?daily_typing_pages?|  +------+------+------------+--------------------+  |??1?|?John?|?2007-01-24?|????????250?|  |??2?|?Ram?|?2007-05-27?|????????220?|  |??3?|?Jack?|?2007-05-06?|????????170?|  |??3?|?Jack?|?2007-04-06?|????????100?|  |??4?|?Jill?|?2007-04-06?|????????220?|  |??5?|?Zara?|?2007-06-06?|????????300?|  |??5?|?Zara?|?2007-02-06?|????????350?|  +------+------+------------+--------------------+  7?rows?in?set?(0.00?sec)

現在,假設根據上表想獲取記錄條件daily_typing_pages超過170,等于和小于300。這可以使用如下條件>=和

mysql&gt;SELECT?*?FROM?employee_tbl?  ??-&gt;WHERE?daily_typing_pages?&gt;=?170?AND  ??-&gt;daily_typing_pages?<p>同樣可以實現使用BETWEEN子句如下:</p><pre class="brush:py;">mysql&gt;?SELECT?*?FROM?employee_tbl?  ??-&gt;?WHERE?daily_typing_pages?BETWEEN?170?AND?300;?  +------+------+------------+--------------------+  |?id??|?name?|?work_date?|?daily_typing_pages?|  +------+------+------------+--------------------+  |??1?|?John?|?2007-01-24?|????????250?|  |??2?|?Ram?|?2007-05-27?|????????220?|  |??3?|?Jack?|?2007-05-06?|????????170?|  |??4?|?Jill?|?2007-04-06?|????????220?|  |??5?|?Zara?|?2007-06-06?|????????300?|  +------+------+------------+--------------------+  5?rows?in?set?(0.03?sec)

? 版權聲明
THE END
喜歡就支持一下吧
點贊13 分享