MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE discounts (
  `id` INTEGER,
  `percentage` INTEGER,
  `from_date` DATETIME,
  `to_date` DATETIME,
  `type_id` INTEGER,
  `tag` VARCHAR(8)
);

INSERT INTO discounts (`id`, `percentage`, `from_date`, `to_date`, `type_id`, `tag`) VALUES
  ('1', '10.00', '2022-04-01 00:00:01', '2022-04-05 23:59:59', '1', 'discount'),
  ('2', '10.00', '2022-04-06 00:00:01', '2022-04-10 23:59:59', '1', 'uplift'),
  ('3', '10.00', '2022-04-12 00:00:01', '2022-04-15 23:59:59', '1', 'discount'),
  ('4', '10.00', '2022-04-20 00:00:01', '2022-04-25 23:59:59', '1', 'uplift');
SELECT * FROM `discounts` 
WHERE type_id = 1 
  AND `from_date` <= '2022-04-05 23:59:59' AND `to_date` >= '2022-04-01 00:00:00';


id
percentage
from_date
to_date
type_id
tag


1
10
2022-04-01 00:00:01
2022-04-05 23:59:59
1
discount


SELECT * FROM `discounts` 
WHERE type_id = 1 
  AND `from_date` <= '2022-04-15 23:59:59' AND `to_date` >= '2022-04-12 00:00:00';


id
percentage
from_date
to_date
type_id
tag


3
10
2022-04-12 00:00:01
2022-04-15 23:59:59
1
discount


SELECT * FROM `discounts` 
WHERE type_id = 1 
  AND `from_date` <= '2022-04-11 23:59:59' AND `to_date` >= '2022-04-11 00:00:00';