MySQL 8.0

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

CREATE TABLE mytable_2025 ( id int)
CREATE  PROCEDURE `mysp`(IN sYear VARCHAR(255))
BEGIN

DECLARE 2sYear VARCHAR(255);
SET 2sYear = sYear;

SET @s = CONCAT('SELECT * FROM `mytable_',2sYear,'`;');
PREPARE stmt FROM @s;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

END
call mysp('2025')
SELECT @s

@s

SELECT * FROM `mytable_2025`;

SELECT @2sYear

@2sYear

null