MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table Contracts (
  id int
, start_date date
, end_date   date
) ;
insert into Contracts( id, start_date, end_date )
values
( 1,'2022-05-01', '2022-05-04' ),
( 2,'2022-05-05', '2022-05-06' ),
( 3,'2022-05-06', '2022-05-10' ),
( 4,'2022-05-01', '2022-05-10' ),
( 5,'2022-05-01', '2022-05-02' ),
( 6,'2022-05-08', '2022-05-10' );
select * from Contracts ;


id
start_date
end_date


1
2022-05-01
2022-05-04

2
2022-05-05
2022-05-06

3
2022-05-06
2022-05-10

4
2022-05-01
2022-05-10

5
2022-05-01
2022-05-02

6
2022-05-08
2022-05-10


select id
from Contracts 
WHERE start_date <= '2022-05-07' AND end_date >= '2022-05-03'
;


id


1

2

3

4


select id
from Contracts 
where 
( start_date <= '2022-05-03' and ( end_date >= '2022-05-03' and end_date <= '2022-05-07' ) ) 
or
( start_date >= '2022-05-03' and end_date <= '2022-05-07' ) 
or
( ( start_date >= '2022-05-03' and start_date <= '2022-05-07' ) and end_date >= '2022-05-07' )
or
( start_date <= '2022-05-03' and end_date >= '2022-05-07' )
;


id


1

2

3

4

id	start_date	end_date
1	2022-05-01	2022-05-04
2	2022-05-05	2022-05-06
3	2022-05-06	2022-05-10
4	2022-05-01	2022-05-10
5	2022-05-01	2022-05-02
6	2022-05-08	2022-05-10