BETWEEN

Overview

Compares the return value of an expression to minimum and maximum arguments. Returns 1 if expression is greater than or equal to the minimum and less than or equal to the maximum, otherwise returns 0.

See also: SQL Operators in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

EXAMPLES

CREATE TABLE between_example (
  v1 INT,
  v2 INT
);
INSERT INTO between_example VALUES
  (0, 9), (1, 8), (2, 7), (3, 6), (4, 5),
  (5, 4), (6, 3), (7, 2), (8, 1), (9, 0);
SELECT * from between_example
WHERE v1 BETWEEN 5 AND 7;
+------+------+
| v1   | v2   |
+------+------+
|    5 |    4 |
|    6 |    3 |
|    7 |    2 |
+------+------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

EXTERNAL REFERENCES