/*
mysql> SELECT ExamID, SustainedOn, Comments FROM Exam
-> WHERE SustainedOn NOT BETWEEN '2003-03-20' AND '2003-03-24';
+--------+-------------+-----------------+
| ExamID | SustainedOn | Comments |
+--------+-------------+-----------------+
| 1 | 2003-03-12 | Java Test |
| 2 | 2004-03-13 | C# test |
| 3 | 2005-03-11 | JavaScript Test |
+--------+-------------+-----------------+
3 rows in set (0.00 sec)
*/
/* Prepare the data */
DROP TABLE Exam;
CREATE TABLE Exam (
ExamID INT NOT NULL PRIMARY KEY,
SustainedOn DATE,
Comments VARCHAR(255)
)TYPE = InnoDB;
/* Insert data for testing */
INSERT INTO Exam (ExamID,SustainedOn,Comments) VALUES (1,'2003-03-12','Java Test');
INSERT INTO Exam (ExamID,SustainedOn,Comments) VALUES (2,'2004-03-13','C# test');
INSERT INTO Exam (ExamID,SustainedOn,Comments) VALUES (3,'2005-03-11','JavaScript Test');
/* Real command */
SELECT ExamID, SustainedOn, Comments FROM Exam
WHERE SustainedOn NOT BETWEEN '2003-03-20' AND '2003-03-24';