WHERE Clause Comparisons : Where : Where Clause SQL / MySQL


SQL / MySQL » Where Clause » Where »

 

WHERE Clause Comparisons



/*
mysql> SELECT ExamID, SustainedOn, Comments FROM Exam
    -> WHERE SustainedOn > '2003-03-20';
+--------+-------------+-----------------+
| ExamID | SustainedOn | Comments        |
+--------+-------------+-----------------+
|      2 | 2004-03-13  | C# test         |
|      3 | 2005-03-11  | JavaScript Test |
+--------+-------------+-----------------+
2 rows in set (0.02 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,CommentsVALUES (1,'2003-03-12','Java Test');
INSERT INTO Exam (ExamID,SustainedOn,CommentsVALUES (2,'2004-03-13','C# test');
INSERT INTO Exam (ExamID,SustainedOn,CommentsVALUES (3,'2005-03-11','JavaScript Test');
  
/* Real command */
  
SELECT ExamID, SustainedOn, Comments FROM Exam
WHERE SustainedOn > '2003-03-20';

           
       



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

SQL / MySQL

 Navioo Where Clause
» Where