Run Trigger according to the value of a column

Question

I need this Rigger to run when there is an update in the table auction, but only when the column value auc_status is equal to 3.

That is, so the value of auc_status is changed to 3, he must run the Trigger.

I tried to do it that way:

DELIMITER $$
CREATE TRIGGER update_bid
    AFTER UPDATE ON auction
    FOR EACH ROW    
BEGIN
IF (NEW.auc_status = '3') THEN
    /* Conteúdo da trigger, que seriam dois updates em outra tabela */
END IF;
END$$
DELIMITER ;

Is this correct or should I do otherwise? I use Mysql.

Answer 1

I think it would be better

DELIMITER $$
CREATE TRIGGER update_bid
    AFTER UPDATE ON auction
    FOR EACH ROW    
BEGIN
IF ((OLD.auc_status <> NEW.auc_status) and (NEW.auc_status = '3')) THEN
    /* Conteúdo da trigger, que seriam dois updates em outra tabela */
END IF;
END$$
DELIMITER ;