MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE my_table (measurement_timestamp  DATE);
INSERT my_table (measurement_timestamp )
VALUES ('2024-02-28'), ('2024-02-29'), ('2024-03-01'), ('2024-03-03'), ('2024-03-05'),
       ('2024-03-11'), ('2024-04-04'), ('2024-04-05');

Records: 8  Duplicates: 0  Warnings: 0


SET @Month ='March';
SET @Year = '2024';

SELECT t.*
FROM my_table AS t
CROSS JOIN (SELECT DATE_FORMAT(STR_TO_DATE(CONCAT_WS(' ','01', @Month, @Year), '%d %M %Y'),'%Y-%m-%d') AS DateStart) AS d
WHERE t.measurement_timestamp >= d.DateStart
AND t.measurement_timestamp< d.DateStart +INTERVAL 1 MONTH;


measurement_timestamp


2024-03-01

2024-03-03

2024-03-05

2024-03-11


SET @Month ='March';
SET @Year = '2024';

SELECT t.measurement_timestamp
FROM my_table AS t
CROSS JOIN (SELECT MAKEDATE(@Year, 1)
				+ INTERVAL 
				CASE
					WHEN @Month = 'January' THEN 0
					WHEN @Month = 'February' THEN 1
					WHEN @Month = 'March' THEN 2
					WHEN @Month = 'April' THEN 3
					WHEN @Month = 'May' THEN 4
					WHEN @Month = 'June' THEN 5
					WHEN @Month = 'July' THEN 6
					WHEN @Month = 'August' THEN 7
					WHEN @Month = 'September' THEN 8
					WHEN @Month = 'October' THEN 9
					WHEN @Month = 'November' THEN 10
					WHEN @Month = 'December' THEN 11
				END MONTH  AS DateStart) AS d
WHERE t.measurement_timestamp >= d.DateStart
AND t.measurement_timestamp< d.DateStart +INTERVAL 1 MONTH;


measurement_timestamp


2024-03-01

2024-03-03

2024-03-05

2024-03-11


SET @Month ='March';
SET @Year = '2024';

SELECT t.measurement_timestamp
FROM my_table AS t
CROSS JOIN (SELECT MAKEDATE(@Year, 1)
				+ INTERVAL 
				FIND_IN_SET(@Month, 'January,February,March,April,May,June,July,August,September,October,November,December') - 1 MONTH  AS DateStart) AS d
WHERE t.measurement_timestamp >= d.DateStart
AND t.measurement_timestamp< d.DateStart +INTERVAL 1 MONTH;


measurement_timestamp


2024-03-01

2024-03-03

2024-03-05

2024-03-11