can't update table 'users' in stored function/trigger because

[Paul Polin]

I am trying to update a table 'users' after update

the username must be = email adress

DELIMITER $$
CREATE TRIGGER trg_user_email AFTER UPDATE ON users
FOR EACH ROW
BEGIN
IF NEW.email <> OLD.email THEN
UPDATE users SET username = email ;
END IF;
END $$

and I am getting
Can't update table 'users' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.


how can I solve it ?

thank you