.sql

CREATE TRIGGER insert_enc BEFORE INSERT ON dmhy_lists
FOR EACH ROW
BEGIN
    IF UPPER(NEW.title) REGEXP '(繁|BIG5)' THEN
        SET NEW.enc = '1';
    ELSEIF UPPER(NEW.title) REGEXP '(简|GB)' THEN
        SET NEW.enc = '2';
    END IF;
END;