這篇文章主要介紹了中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>SELECT?*?FROM?employee_tbl? ??->WHERE?daily_typing_pages?>=?170?AND ??->daily_typing_pages?<p>同樣可以實現使用BETWEEN子句如下:</p><pre class="brush:py;">mysql>?SELECT?*?FROM?employee_tbl? ??->?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