CREATE TABLE Employee (
  `id` int, 
  `name` varchar(255)
);
CREATE TABLE Availability (
  `id` int,
  `start` DATETIME,
  `end` DATETIME,
  `user_id` int
);
 
INSERT INTO Employee
	(`id`, `name`)
VALUES
	(1, 'Mike');
 
INSERT INTO Availability
  (`id`, `start`, `end`, `user_id`)
VALUES
  (1, '2016-01-01 12:00:00', '2016-01-01 17:00:00', 1),
  (2, '2016-01-01 14:00:00', '2016-01-01 19:00:00', 1);
 
 
SELECT * 
FROM Availability
WHERE '2016-01-01 18:00:00' AND '2016-01-01 18:30:00'
BETWEEN start AND end;
 

Q1JFQVRFIFRBQkxFIEVtcGxveWVlICgKICBgaWRgIGludCwgCiAgYG5hbWVgIHZhcmNoYXIoMjU1KQopOwpDUkVBVEUgVEFCTEUgQXZhaWxhYmlsaXR5ICgKICBgaWRgIGludCwKICBgc3RhcnRgIERBVEVUSU1FLAogIGBlbmRgIERBVEVUSU1FLAogIGB1c2VyX2lkYCBpbnQKKTsKCQpJTlNFUlQgSU5UTyBFbXBsb3llZQoJKGBpZGAsIGBuYW1lYCkKVkFMVUVTCgkoMSwgJ01pa2UnKTsKICAgIApJTlNFUlQgSU5UTyBBdmFpbGFiaWxpdHkKICAoYGlkYCwgYHN0YXJ0YCwgYGVuZGAsIGB1c2VyX2lkYCkKVkFMVUVTCiAgKDEsICcyMDE2LTAxLTAxIDEyOjAwOjAwJywgJzIwMTYtMDEtMDEgMTc6MDA6MDAnLCAxKSwKICAoMiwgJzIwMTYtMDEtMDEgMTQ6MDA6MDAnLCAnMjAxNi0wMS0wMSAxOTowMDowMCcsIDEpOwogIAoKU0VMRUNUICogCkZST00gQXZhaWxhYmlsaXR5CldIRVJFICcyMDE2LTAxLTAxIDE4OjAwOjAwJyBBTkQgJzIwMTYtMDEtMDEgMTg6MzA6MDAnCkJFVFdFRU4gc3RhcnQgQU5EIGVuZDsK