This seems like it should be so simple but I'm having a hell of a time solving it.
I have 10 tables named in the following way:
b1_settings
b2_settings
...
b10_settings
I need to search across all of them, and return one specific field for all records with weight=0
. Basically I want to do this (which is of course invalid):
select title from *_settings where weight=0
Is there any way to accomplish this using PHPMyAdmin or MySQL Workbench (I have to avoid command line solutions in this instance) without a huge ugly query that specified each and every table individually?