MySQL 8.0

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

CREATE PROCEDURE `sp_test`(
IN spsID VARCHAR(255),
IN spsName VARCHAR(255))
BEGIN

DECLARE m LONGTEXT DEFAULT '';

FLUSH HOSTS;

IF spsID <> "-" THEN 
   SET spsID = spsID; 
   SET m = CONCAT(m, 'AND sID = \'', spsID, '\'');
END IF;

IF spsName <> "-" THEN 
   SET spsName = spsName;
   SET m = CONCAT(m, ' AND sName = \'', spsName, '\'');
END IF;

SET @s = CONCAT('SELECT * FROM `tbl_a` t WHERE 1 ',m,';');

SELECT @s;

PREPARE `stmt` FROM @`s`;
SET @`s` := NULL;
EXECUTE `stmt`;
DEALLOCATE PREPARE `stmt`;
END;
CALL `sp_test`('2022-0001', 'foo');

@s

SELECT * FROM `tbl_a` t WHERE 1 AND sID = '2022-0001' AND sName = 'foo';

Table 'fiddle.tbl_a' doesn't exist

SELECT CONCAT('', 'A');

CONCAT('', 'A')

A