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),
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 |