ANTICHAT — форум по информационной безопасности, OSINT и технологиям

delimiter ;;
CREATE PROCEDURE cl()
BEGIN
  DECLARE done INT DEFAULT 0;
  DECLARE s VARCHAR(100);  
  DECLARE cur CURSOR FOR SELECT DISTINCT SUBSTRING_INDEX(`title`,' ',2) FROM `table`;
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
  OPEN cur;
  REPEAT
    FETCH cur INTO s;
    DELETE FROM `table` WHERE `id` IN (SELECT `t1`.`id` FROM (SELECT * FROM `table`) as `t1` WHERE `t1`.`title` LIKE CONCAT(s,'%') AND `id` <> (SELECT `t2`.`id` FROM (SELECT * FROM `table`) as `t2` WHERE `t2`.`title` LIKE CONCAT(s,'%') LIMIT 1));
  UNTIL done END REPEAT;
END;;

call cl()