I've searched online for a solution and didn't find anything specific to my problem. Stackoverflow is a great source, btw.
The desired outcome will make updates to all level 1, then level 2, 3, 4 and up. This query does not do this. Is there a way to make the query sort by level first then apply updates?
Code:
update loottable_copy,npc_types set mincash = floor(0.2 * (pow(`level`,2)) - 3 * `level` + 5)
where npc_types.loottable_id = loottable_copy.id and npc_types.level < 71
and loottable_copy.mincash != 0 and npc_types.name regexp'(^a\_|^an\_)' and race = 60;
Thanks