Prevent Insert With Trigger - How is it done?

[Frank Yingst]

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

I then do this: INSERT INTO addressbook (counselName) values ('Select');

It adds the value to the table. How do I prevent the adding of the value to the table? I want to reject the value as if the INSERT statement was never issued.