Kryptix Posted August 17, 2011 Share Posted August 17, 2011 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; Quote Link to comment https://forums.phpfreaks.com/topic/245038-wildcard/ Share on other sites More sharing options...
fenway Posted August 17, 2011 Share Posted August 17, 2011 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.... Quote Link to comment https://forums.phpfreaks.com/topic/245038-wildcard/#findComment-1258645 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.