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
Hi,
I'd like to use a mysql database as a lookup to authorize people to edit a
webpage. The idea is that people would go to a main login page for
authentication and then when they visit a page they are authorized to edit,
they see an edit this page link.
What I'm envisioning is a really
will crash :)
-Original Message-
From: Bob Ramsey [mailto:[EMAIL PROTECTED]
Sent: maandag 12 januari 2004 19:26
To: [EMAIL PROTECTED]
Subject: wildcards the field
Hi,
I'd like to use a mysql database as a lookup to authorize people to edit
a
webpage. The idea is that people would go
Hi,
I'd like to use a mysql database as a lookup to authorize people to edit a
webpage. The idea is that people would go to a main login page for
authentication and then when they visit a page they are authorized to edit,
they see an edit this page link.
What I'm envisioning is a really