Re: Prevent Insert With Trigger - How is it done?

[Frank Yingst]

Here is the new statement. Same problem. Still inserts the value.

CREATE TRIGGER addressbook_upd_check BEFORE UPDATE ON addressbook
FOR EACH ROW
BEGIN
IF SUBSTRING(NEW.counselName,1,6) = 'Select' THEN
SIGNAL SQLSTATE '45000';
END IF;
END;