CREATE DEFINER=`root`@`localhost` PROCEDURE `killa`()
BEGIN
SET @a='123<a href=\'www.fsda.com\'>456<a href=\'www.fasdfew.com\'>789';
SET @b=INSTR(@a,'<');
WHILE @b>0 DO
SET @a=CONCAT(LEFT(@a,@b-1),MID(@a,INSTR(@a,'>')+1));
SET @b=INSTR(@a,'<');
END WHILE;
SELECT @a;
END$$