Comparison Functions – In And Not In

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

SELECT * FROM `try` WHERE number IN (4, 5, 8);

SELECT * FROM `try` WHERE number IN (4, 5, 8, 'Osama', 100);

SELECT * FROM `try` WHERE date IN ('2016-05-25', '2016-05-18');

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

SELECT * FROM `try` WHERE number NOT IN (3, 7);

SELECT * FROM `try` WHERE date NOT IN ('2016-07-16');