Help making some SQL Quieries

[controlsx2]

Well im really bad at these things so im wordering if somone can help me
i tried to make my server with a level cap or 325, But arc-emu doesnt support a cap higher than 80 without some major core editing on how stats are calculated which i dont think im advanced enough for yet. So i want to revert it back to 80 what i need are quieries that will

Modify all items with a requiredlevel > 80 to become 80 e.g
Modify 'items' where 'requiredlevel' > 80 to 'requiredlevel' = 80

Modify all chars with a level > 80 to 80 e.g
Modify 'characters' where 'level' > 80 to 'level' 80

All mobs with a level > 80 become 80.

If somone could help me id be really greatful

Thanks in advance,
Controlsx2

[Henkke]

update items set requiredlevel = 80 where requiredlevel > 80;
update characters set level = 80 where level > 80;
update creature_proto set minlevel=80 where minlevel > 83;
update creature_proto set maxlevel=80 where maxlevel > 83;

[controlsx2]

Thanks they all work great! +rep