Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT CONCAT('UPDATE ', TABLE_NAME, ' SET ', column_name, ' = REPLACE(`', column_name, '`, ''twilight_forest'', ''DIM7'');' )
- FROM information_schema.COLUMNS
- WHERE TABLE_NAME
- IN ('TOWNY_NATIONS', 'TOWNY_RESIDENTS', 'TOWNY_TOWNBLOCKS', 'TOWNY_TOWNS', 'TOWNY_WORLDS');
- SELECT CONCAT('UPDATE ', TABLE_NAME, ' SET ', column_name, ' = REPLACE(`', column_name, '`, ''world_nether'', ''DIM-1'');' )
- FROM information_schema.COLUMNS
- WHERE TABLE_NAME
- IN ('TOWNY_NATIONS', 'TOWNY_RESIDENTS', 'TOWNY_TOWNBLOCKS', 'TOWNY_TOWNS', 'TOWNY_WORLDS');
Advertisement
Add Comment
Please, Sign In to add comment