delimiter $
create trigger cars_number_validate_2 before update on cars
for each row
begin
if new.number not REGEXP '^[0-9]+$'
then
signal sqlstate '45000'
set message_text = 'bad number';
end
if;
end$
delimiter;