Hi all I have 5 blogs in one database and wish to select the option table from the DB all at one once and get the same row from each table. Is there a way I could use a wild card to select each table without calling each table in the select as i will be having more eg this is the database blog1option blog2option blog3option blog4option blog5option Select ID FROM %option% Where ID= '33'
I don't believe there's a wildcard that does it, but you could consalidate the information I believe with some subqueries. The concept is to create "temporary tables" and select from them. I know there are "merge" options as well.
You could create a VIEW (http://dev.mysql.com/doc/refman/5.0/en/create-view.html) and then query that one with one line of code