Fulltext_remove_doc

sql

PROCEDURE Fulltext_remove_doc(IN ft_label CHAR(52), IN docid INT);

Parameters:

ft_label fulltext system label;
docid document id

Since version:

7.0

Description:

This function removes the selected document from the indexes of the fulltext system specified in the ft_label parameter.

The Fulltext_remove_doc function doesn't have to be called after modifying the document before calling the Fulltext_index_doc function, because the old contents are removed when reindexing automatically. This function may be called e.g. in a trigger for DELETE operation on table containing documents.

Example:

TRIGGER txdel BEFORE DELETE ON Txtab
REFERENCING OLD AS old FOR EACH ROW
BEGIN
   CALL Fulltext_remove_doc(".FT_FORUM", old.doc_id);
END

See