/* Using where with different comparison operators */

SELECT * FROM student
WHERE student_id < 10;

SELECT  *  FROM  student
WHERE student_id <= '10';               /*With quotes, don't do that*/

SELECT * FROM  student
WHERE fname >= 'M';                     /*All names starting with M or greater*/

SELECT * FROM  student
WHERE fname != 'David';                 /*Case sensitive? Try it in both Oracle and MySql*/

SELECT * FROM  student
WHERE student_id BETWEEN 5 AND 10;

SELECT * FROM  student
WHERE lname NOT BETWEEN 'A' AND 'Myers';

SELECT * FROM student                            /*ORACLE*/ 
WHERE lname BETWEEN 'a' AND 'zzzzzz';            /*Lastnames starting with lowercase only*/

SELECT * FROM student                            /*MYSQL*/ 
WHERE binary lname BETWEEN 'a' AND  'zzzzzz';    /*Lastnames starting with lowercase only*/