MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `tbl_bookings` (
  `BookingID` int(11) NOT NULL AUTO_INCREMENT,
  `userID` varchar(100) DEFAULT NULL,
  `VehicleId` int(11) DEFAULT NULL,
  `FromDate` date DEFAULT NULL,
  `ToDate` date DEFAULT NULL,
  `Comments` varchar(255) DEFAULT NULL,
  `TotalPrice` varchar(255) DEFAULT NULL,
  `Status` varchar(10) DEFAULT NULL,
  `PostingDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `LastUpdationDate` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`BookingID`)
) ENGINE=InnoDB AUTO_INCREMENT=362 DEFAULT CHARSET=utf8;
INSERT INTO tbl_bookings (BookingID, userID, VehicleId, FromDate, ToDate, Comments, TotalPrice, Status, PostingDate, LastUpdationDate) VALUES
(282, '20', 1003, '2021-10-07', '2021-10-10', 'Lorem Ipsum Dollor', '624', 'Cancelled', '2021-08-03 15:49:34', '2021-08-05 12:55:40'),
(283, '22', 1009, '2021-11-03', '2021-11-11', 'Lorem Ipsum Dollor', '2241', 'Cancelled', '2021-08-03 15:49:34', '2021-08-05 12:55:40'),
(284, '19', 1003, '2021-08-25', '2021-08-28', 'Lorem Ipsum Dollor', '624', 'Cancelled', '2021-08-03 15:49:34', '2021-08-05 12:55:40'),
(285, '17', 1009, '2021-10-15', '2021-10-22', 'Lorem Ipsum Dollor', '1992', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(286, '17', 1019, '2021-08-28', '2021-08-29', 'Lorem Ipsum Dollor', '1800', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(287, '18', 1005, '2021-11-18', '2021-11-25', 'Lorem Ipsum Dollor', '1536', 'Cancelled', '2021-08-03 15:49:34', '2021-08-05 12:55:40'),
(288, '21', 1013, '2021-08-24', '2021-08-30', 'Lorem Ipsum Dollor', '2310', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(289, '24', 1010, '2021-10-25', '2021-10-29', 'Lorem Ipsum Dollor', '745', 'Confirmed', '2021-08-03 15:49:34', '2021-08-05 12:55:07'),
(290, '24', 1013, '2021-10-13', '2021-10-23', 'Lorem Ipsum Dollor', '3630', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(291, '24', 1014, '2021-09-23', '2021-10-03', 'Lorem Ipsum Dollor', '3960', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(292, '22', 1008, '2021-12-17', '2021-12-22', 'Lorem Ipsum Dollor', '1440', 'Confirmed', '2021-08-03 15:49:34', '2021-08-05 12:55:07'),
(293, '22', 1015, '2021-09-14', '2021-09-21', 'Lorem Ipsum Dollor', '1032', 'Cancelled', '2021-08-03 15:49:34', '2021-08-05 12:55:40'),
(294, '19', 1014, '2021-11-23', '2021-11-29', 'Lorem Ipsum Dollor', '2520', 'Confirmed', '2021-08-03 15:49:34', '2021-08-05 12:55:07'),
(295, '23', 1018, '2021-08-18', '2021-08-25', 'Lorem Ipsum Dollor', '12000', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(296, '22', 1020, '2021-08-11', '2021-08-12', 'Lorem Ipsum Dollor', '3000', 'Confirmed', '2021-08-03 15:49:34', '2021-08-05 12:55:07'),
(297, '25', 1001, '2021-11-30', '2021-12-09', 'Lorem Ipsum Dollor', '1350', 'Confirmed', '2021-08-03 15:49:34', '2021-08-05 12:55:07'),
(298, '17', 1009, '2021-09-20', '2021-09-24', 'Lorem Ipsum Dollor', '1245', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(299, '21', 1017, '2021-10-15', '2021-10-25', 'Lorem Ipsum Dollor', '6930', 'Cancelled', '2021-08-03 15:49:34', '2021-08-05 12:55:40'),
(300, '22', 1018, '2021-11-17', '2021-11-21', 'Lorem Ipsum Dollor', '7500', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(301, '24', 1006, '2021-09-02', '2021-09-06', 'Lorem Ipsum Dollor', '1050', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(302, '21', 1011, '2021-12-24', '2021-12-26', 'Lorem Ipsum Dollor', '810', 'Cancelled', '2021-08-03 15:49:34', NULL),
(303, '25', 1016, '2021-09-27', '2021-10-05', 'Lorem Ipsum Dollor', '5400', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(304, '24', 1004, '2021-10-08', '2021-10-09', 'Lorem Ipsum Dollor', '348', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(305, '25', 1004, '2021-09-08', '2021-09-14', 'Lorem Ipsum Dollor', '1218', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(306, '21', 1016, '2021-10-20', '2021-10-22', 'Lorem Ipsum Dollor', '1800', 'Confirmed', '2021-08-03 15:49:34', '2021-08-05 12:55:07'),
(307, '24', 1007, '2021-12-12', '2021-12-17', 'Lorem Ipsum Dollor', '1440', 'Cancelled', '2021-08-03 15:49:34', '2021-08-05 12:55:40'),
(308, '24', 1003, '2021-11-02', '2021-11-10', 'Lorem Ipsum Dollor', '1404', 'Confirmed', '2021-08-03 15:49:34', '2021-08-05 12:55:07'),
(309, '19', 1013, '2021-11-26', '2021-11-30', 'Lorem Ipsum Dollor', '1650', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(310, '20', 1002, '2021-09-29', '2021-10-08', 'Lorem Ipsum Dollor', '1560', 'Cancelled', '2021-08-03 15:49:34', '2021-08-05 12:55:40'),
(311, '23', 1006, '2021-08-15', '2021-08-20', 'Lorem Ipsum Dollor', '1260', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(312, '20', 1014, '2021-08-10', '2021-08-15', 'Lorem Ipsum Dollor', '2160', 'Cancelled', '2021-08-03 15:49:34', NULL),
(313, '24', 1020, '2021-08-31', '2021-09-08', 'Lorem Ipsum Dollor', '13500', 'Pending', '2021-08-03 15:49:34', '2021-08-05 12:15:10'),
(358, '18', 1009, '2021-10-30', '2021-11-09', 'Lorem Ipsum Dollor', '2739', 'Cancelled', '2021-08-03 15:49:40', NULL),
(359, '23', 1001, '2021-09-25', '2021-09-30', 'Lorem Ipsum Dollor', '810', 'Cancelled', '2021-08-03 15:49:40', '2021-08-05 12:55:40'),
(360, '23', 1011, '2021-12-11', '2021-12-21', 'Lorem Ipsum Dollor', '2970', 'Cancelled', '2021-08-03 15:49:40', NULL),
(361, '17', 1010, '2021-11-03', '2021-11-05', 'Lorem Ipsum Dollor', '447', 'Cancelled', '2021-08-03 15:49:40', NULL);

SELECT BookingID, userID, VehicleId, FromDate, ToDate, Status 
FROM tbl_bookings 
WHERE VehicleID='1009';

Records: 36  Duplicates: 0  Warnings: 0




BookingID
userID
VehicleId
FromDate
ToDate
Status


283
22
1009
2021-11-03
2021-11-11
Cancelled

285
17
1009
2021-10-15
2021-10-22
Pending

298
17
1009
2021-09-20
2021-09-24
Pending

358
18
1009
2021-10-30
2021-11-09
Cancelled


SELECT NOT EXISTS (
         SELECT 1
         FROM tbl_bookings
         WHERE VehicleId = '1009'
           AND Status IN ('Pending', 'Confirmed')
           AND FromDate <= '2021-12-22' AND ToDate >= '2021-12-15' 
       ) availability 


availability


1


SELECT NOT EXISTS (
         SELECT 1
         FROM tbl_bookings
         WHERE VehicleId = '1009'
           AND Status IN ('Pending', 'Confirmed')
           AND FromDate <= '2021-10-27' AND ToDate >= '2021-10-15' 
       ) availability 


availability


0


SELECT NOT EXISTS (
         SELECT 1
         FROM tbl_bookings
         WHERE VehicleId = '1009'
           AND Status IN ('Pending', 'Confirmed')
           AND FromDate <= '2021-10-23' AND ToDate >= '2021-10-14' 
       ) availability 


availability


0


SELECT NOT EXISTS (
         SELECT 1
         FROM tbl_bookings
         WHERE VehicleId = '1009'
           AND Status IN ('Pending', 'Confirmed')
           AND FromDate <= '2021-10-22' AND ToDate >= '2021-10-14' 
       ) availability 


availability


0
BookingID	userID	VehicleId	FromDate	ToDate	Status
283	22	1009	2021-11-03	2021-11-11	Cancelled
285	17	1009	2021-10-15	2021-10-22	Pending
298	17	1009	2021-09-20	2021-09-24	Pending
358	18	1009	2021-10-30	2021-11-09	Cancelled