BETWEEN 条件

当 BETWEEN 左边的值在 BETWEEN 右边的两个值的范围之内时，BETWEEN 条件是满足的。下列示例中的前两个查询在 BETWEEN 关键字之后使用文字值。第三个查询使用内建的 CURRENT 函数和一个文字间隔来搜索当天与七天前之间的日期。

SELECT stock_num, manu_code FROM stock
        WHERE unit_price BETWEEN 125.00 AND 200.00;
        SELECT DISTINCT customer_num, stock_num, manu_code
        FROM orders, items
        WHERE order_date BETWEEN '6/1/07' AND '9/1/07';
        SELECT * FROM cust_calls WHERE call_dtime
        BETWEEN (CURRENT - INTERVAL(7) DAY TO DAY) AND CURRENT;