List:Brisbane MySQL Users Group« Previous MessageNext Message »
From:Mark Unwin Date:August 18 2005 6:25am
Subject:Search thru all fields in a table
View as plain text  
Is there a shortcut way (rather than manually doing a SQL Statement for
each column), to search ALL columns in a table ?
I have people wishing to search for text in different fields - and I'd
like to know if there is a way to query for all columns on a given table
in one SQL statement. (yes, I'm being lazy - or is that efficient
?!?!?!). Or maybe a selection of columns. Or even all columns in all
tables (don't ask).

Mark Unwin.


*************************************************************************************************
This message and any attachments, or any part
of it is intended solely for the named addressee.  

Reading, printing, distribution, storing, commercialising
or acting on this transmission or any information it contains, by anyone other than the
addressee, is prohibited. If you have received this message in error, please destroy all
copies and notify 
Qld Police Credit Union Ltd on +61 7 3008 4444 or by replying to the sender.

This message may contain legally privileged and
confidential information, and/or copyright material
of QPCU or third parties.

QPCU is not responsible for any changes made
to a document other than those made by QPCU,
or for the effect of the changes on the document's meaning.
You should only re-transmit, distribute or commercialise
the material if you are authorised to do so.

Any views expressed in this message are
those of the individual sender.  You may not rely on this message as advice unless
subsequently confirmed by fax or letter signed by an Officer or Director of QPCU, or 
an Authorised Representative QPCU.

QPCU advises that this e-mail and any attached files should be scanned to detect viruses. 
QPCU accepts no liability for loss or damage (whether caused by negligence or not)
resulting from the use of any attached files.

Information regarding Privacy can be found at the QPCU web site. ( www.qpcu.org.au )

General Advice Warning

Any advice has been prepared without taking into account your particular objectives,
financial situation or needs.  For that reason, before acting on the advice you should
consider the appropriateness of the advice having regard to your own objectives,
financial situation and needs.  Where the advice relates to the acquisition, or possible
acquisition, of a particular financial product, you should obtain a Product Disclosure
Statement relating to the product and consider the Product Disclosure Statement before
making any decision about whether to acquire the product.
*************************************************************************************************


Thread
Search thru all fields in a tableMark Unwin18 Aug
  • Re: Search thru all fields in a tableArjen Lentz22 Aug
    • Re: Search thru all fields in a tableMorgan Tocker22 Aug