Wildcard?

[Kryptix]

UPDATE `RSCEmulation`.`rscd_experience` SET `attack_rank` = null, `defense_rank` = null, `strength_rank` = null, `hits_rank` = null, `ranged_rank` = null, `magic_rank` = null, `prayer_rank` = null, `cooking_rank` = null, `woodcut_rank` = null, `fletching_rank` = null, `fishing_rank` = null, `firemaking_rank` = null, `crafting_rank` = null, `smithing_rank` = null, `mining_rank` = null, `herblaw_rank` = null, `agility_rank` = null, `thieving_rank` = null, `runecrafting_rank` = null, `total_xp_rank` = null;

 

Is it possible to do something like...

 

UPDATE `RSCEmulation`.`rscd_experience` SET `%_rank` = null;

[fenway]

If you have a DB wrapper, maybe.  But it's a simple for() loop to generate the SQL -- which I hope you're not writing by hand....