Comparison Functions – Between And Not Between

/*
  Between
  number => Field Name
  date => Field Name
*/

SELECT * FROM `try` WHERE number BETWEEN 2 AND 6;

SELECT * FROM `try` WHERE date BETWEEN '2016-05-18' AND '2016-05-25';

SELECT
  *
FROM
  `try`
WHERE
  date
BETWEEN
  DATE_SUB(CURDATE(), INTERVAL 2 MONTH)
AND
  CURDATE();

SELECT
  *
FROM
  `try`
WHERE
  date
BETWEEN
  DATE_SUB(CURDATE(), INTERVAL 1 YEAR)
AND
  CURDATE();

/*
  Not Between
  number => Field Name
  date => Field Name
*/

SELECT * FROM `try` WHERE number NOT BETWEEN 2 AND 6;