UPDATE entity_request er JOIN ( SELECT id, CASE (grp % 8) WHEN 0 THEN 'Normal 5;Captcha 5' WHEN 1 THEN 'Normal 7;Captcha 7' WHEN 2 THEN 'Normal 8;Captcha 8' WHEN 3 THEN 'Normal 9;Captcha 9' WHEN 4 THEN 'Normal A;Captcha A' WHEN 5 THEN 'Normal C;Captcha C' WHEN 6 THEN 'Normal D;Captcha D' WHEN 7 THEN 'Normal E;Captcha E' END AS new_tool FROM ( SELECT id, entity_email, @grp := IF(@prev_email = entity_email, @grp, @grp + 1) AS grp, @prev_email := entity_email FROM entity_request JOIN (SELECT @grp := -1, @prev_email := '') vars WHERE status = 're_run' AND userId = '0196ad7d-737d-7301-9272-69ca7599e503' ORDER BY entity_email, id ) t ) x ON er.id = x.id SET er.id_tool = x.new_tool;