begin declare twoback int(4); declare lastlevel int(4); declare currentlevel int(4); declare leveltofind int(4); declare diff int(4); set twoback = 0; set lastlevel = 200; set currentlevel = 2; set leveltofind = 5; label1: LOOP if leveltofind = 2 then leave label2; end if; SET diff = lastlevel - twoback; SET diff = diff + 400; SET twoback = lastlevel; SET lastlevel = lastlevel + diff; SET currentlevel = currentlevel+1; if leveltofind = currentlevel then leave label2; end if; iterate label1; END LOOP label1; select lastlevel; end