MySQL 8.0

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

select version();


version()


8.0.30


CREATE TABLE mytable ( 
ID VARCHAR(20) ,
Name VARCHAR(20) ,
Startdate DATE ,
enddate DATE );

INSERT INTO  mytable  VALUES
('1','robert','2024-01-01','2024-01-31'),
('2','ann','2024-01-13','2024-01-20'),
('3','ken','2024-01-20','2024-01-25'),
('4','marco','2024-01-20','2024-01-30');

Records: 4  Duplicates: 0  Warnings: 0


SELECT * FROM mytable order by ID;


ID
Name
Startdate
enddate


1
robert
2024-01-01
2024-01-31

2
ann
2024-01-13
2024-01-20

3
ken
2024-01-20
2024-01-25

4
marco
2024-01-20
2024-01-30


WITH recursive dates AS (
  SELECT MIN(Startdate) as d FROM mytable
  UNION ALL
  SELECT DATE_ADD(d,INTERVAL 1 DAY) FROM dates WHERE d <= (SELECT MAX(enddate) FROM mytable)
)
SELECT m.Name, d.d
FROM dates d
JOIN mytable m ON d.d BETWEEN m.Startdate and m.enddate
WHERE DAYOFWEEK(d) = 1
ORDER BY d.d;


Name
d


robert
2024-01-07

robert
2024-01-14

ann
2024-01-14

robert
2024-01-21

ken
2024-01-21

marco
2024-01-21

robert
2024-01-28

marco
2024-01-28

ID	Name	Startdate	enddate
1	robert	2024-01-01	2024-01-31
2	ann	2024-01-13	2024-01-20
3	ken	2024-01-20	2024-01-25
4	marco	2024-01-20	2024-01-30

Name	d
robert	2024-01-07
robert	2024-01-14
ann	2024-01-14
robert	2024-01-21
ken	2024-01-21
marco	2024-01-21
robert	2024-01-28
marco	2024-01-28