Jason Joines wrote:
Is it possible to use a wildcard for field names in a select?
No.
For instance if I have a table with a hundred columns and I want to retrieve all rows who have a certain value in any column but don't want to type in a hundred column names in my query, how do I do it?
I've tried:
select * from db.table where * = 'w';
select * from db.table where % = 'w';
select * from db.table where '*' = 'w';
select * from db.table where '%' = 'w';
but none work. The first two give a syntax error and the second two return an empty set.
Thanks,
Jason Joines ================================
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
