Before Insert Trigger

[Pete Elliott]

I have a table (chain) which has unique identifiers under TagId column re: numbers 1 through to 50.

I am trying to set up a trigger which inserts into another table (chain_gear) however I only wish to show TagId "11" within the chain_gear table

I cannot seem to be able to use "WHERE" statements or "IF" statements within the trigger

The present trigger query I have is quite simple and is updating my chain_gear table but it is updating it with all the other TagId as it is and I only need it to update entries for TagId "11", present code is below:

CREATE TRIGGER `chain`.`chain_tagshistory_BEFORE_INSERT` BEFORE INSERT ON `chain_tagshistory` FOR EACH ROW
BEGIN
INSERT INTO chain_gear (TagId, Val, _date)
VALUES (NEW.TagId, NEW.Val, NEW._date);
END