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
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?
In article [EMAIL PROTECTED],
Jason Joines [EMAIL PROTECTED] writes:
Is it possible to use a wildcard for field names in a select?
Nope.
For instance if I have a table with a hundred columns...
... then you have probably a broken DB design. What are you trying to do?
--
MySQL