You can't specify target table for update in FROM clause Solution

You can't specify target table for update in FROM clause Solution

#old query
UPDATE `user` as u SET `field`="new value" WHERE id > (select max(au.id) from `user` as au where u.id > au.id)
#new query
UPDATE `user` as u SET `field`="new value" WHERE id > (select max(au.id) from (select id from`user`) as au where u.id > au.id)