SET @find = OLD.find;

while @find <> "" do

      SET @head = SUBSTRING(@find, 1, LOCATE(" ", concat(@find, " "))-1);

      SET @find = SUBSTRING(@find, LOCATE(" ", concat(@find, " "))+1);

      UPDATE `find` SET `book`=REPLACE(`book`, concat(" ", OLD.guid, " "), " ")

      WHERE `word`=@head;

end while;

 

SET @find = NEW.find;

while @find <> "" do

      SET @head = SUBSTRING(@find, 1, LOCATE(" ", concat(@find, " "))-1);

      SET @find = SUBSTRING(@find, LOCATE(" ", concat(@find, " "))+1);

      INSERT `find` SET `word`=@head, book=concat(" ", NEW.guid, " ")

      ON duplicate KEY UPDATE book=concat(book, NEW.guid, " ");

end while;