We have software in which when users signup for a phpBB forum, it creates them in a DB using this format: username_config, username_tablename, etc... Well, if we need to update the DB for every user, and we have 75 users, that would be a tedious task. Is there a simple way of updating the whole DB for certain tables using a query?
For example, lets say I wanted to update everyone's _config table. I tried running,
INSERT INTO *_config (config_name, config_value) VALUES ('board_disable_msg', '');
INSERT INTO *_config (config_name, config_value) VALUES ('board_disable_mode', '-1,0');
I thought maybe the * would act as a wildcard, but it didn't work.