MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE account(
accountID INT,
account_type varchar(20),
priority int  );





create trigger validation_check before insert on account for each row
begin
  if ((new.account_type not in ('normal','administrator','guest'))  and (new.priority > 100 or new.priority < 0)) 
    then signal SQLSTATE '45000'
    set message_text  = 'The type of account which you gave was invalid or the priority cannot be inserted!';
End if;
end
insert into account (accountID, account_type, priority) values 
(315,'administrator',100),
(422,'normal',50),
(22,'guest',20);

Records: 3  Duplicates: 0  Warnings: 0


insert into account (accountID, account_type, priority) values 
(1,'test1',300);

The type of account which you gave was invalid or the priority cannot be inserted!


select * from account;


accountID
account_type
priority


315
administrator
100

422
normal
50

22
guest
20