boll wrote:
Hello-
I'm working with an unfamiliar application, trying to figure out where
my data is going.
Is it possible to form a query to select from all the columns in
several tables at once? Something equivalent to:
SELECT FROM * WHERE * = 'john smith'; If that's not possible I'd
still like to be able to search each table at once without specifying
the column names:
SELECT FROM <table name> WHERE * = 'john smith';
If that can't be done, can a sub query find the column names to be
selected on?
Basically, I'm trying to avoid doing separate selects on each column
in each table.
This is using MySQL 5.0.27 .
Thanks for any suggestion or alternative methods!
-John
SELECT * FROM table1, table2, table3 WHERE table1.name = 'john smith'
AND table2.city = 'Dallas'
If the tables have fields named the same, this may not work very well.
Then you'd need to list out the column names and alias some of them so
they come out with different names.
I don't think there is a way to wildcard the column names like you are
asking, I can't imagine a case where you'd need to do that either. When
would every column in your table have the same value? (john smith in
your example).
You can programmatically get a list of columns in a table, then when you
are using Perl or PHP or whatever to build your query string, you can
loop through the columns to list them.
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]