范围：BETWEEN ... AND

← 返回 Python3 MySQL 数据库

57.9 范围：BETWEEN ... AND

BETWEEN a AND b 表示 a ≤ 值 ≤ b（含边界）。

NOT BETWEEN a AND b 表示在范围外。

也可用于日期、字符串（按字典序）。

分数区间

import pymysql

conn = pymysql.connect(host='127.0.0.1', user='root', password='root', database='py_demo', charset='utf8mb4')
try:
    with conn.cursor() as cur:
        cur.execute(
            'SELECT name, score FROM students WHERE score BETWEEN %s AND %s',
            (80, 95)
        )
        print('80~95分：', cur.fetchall())
        cur.execute(
            'SELECT name, score FROM students WHERE score NOT BETWEEN %s AND %s',
            (70, 90)
        )
        print('70~90分以外：', cur.fetchall())
finally:
    conn.close()