selects with wildcards for field/column names

[Jason Joines]

	Is it possible to use a wildcard for field names in a select?  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]