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]