CODE EXAMPLE FOR SQL

mysql between start date and end date

SELECT
	* 
FROM
	tlcc_talent_periode 
WHERE
	company = '1000' 
	AND (
	
	(start_date >= '2022-04-01' AND end_date <= '2022-04-01')
	OR
	(start_date <= '2022-04-30' AND end_date >= '2022-04-30' )
	
	OR
	
	
	(start_date <= '2022-04-01' AND end_date >= '2022-04-01')
	OR
	(start_date >= '2022-04-30' AND end_date <= '2022-04-30' )
	
	)