MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `stripoutwords` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO stripoutwords VALUES (1,'test'),(1,'abc')

Records: 2  Duplicates: 0  Warnings: 0


CREATE function Removetext (
	 texttofilter text
) RETURNS TEXT DETERMINISTIC
BEGIN
	DECLARE finished INTEGER DEFAULT 0;
	DECLARE stopwords TEXT DEFAULT "";

	-- declare cursor for employee email
	DEClARE curlist 
		CURSOR FOR 
			SELECT `name` FROM `stripoutwords`;

	-- declare NOT FOUND handler
	DECLARE CONTINUE HANDLER 
        FOR NOT FOUND SET finished = 1;

	OPEN curlist;

	getwordlist: LOOP
		FETCH curlist INTO stopwords;
		IF finished = 1 THEN 
			LEAVE getwordlist;
		END IF;
		-- build email list
		SET texttofilter = REPLACE (texttofilter,stopwords,"");
	END LOOP getwordlist;
	CLOSE curlist;
RETURN texttofilter;
END
SELECT Removetext ('test a abc')


Removetext ('test a abc')


 a