searching across all fields in a row

#1

Hi

SELECT * FROM TABLE123 WHERE FULLNAME LIKE 'RED'

The above will only check one variable FULLNAME.

Is there anyway of searching across all fields in the row without listing
each variable?

There could be over 100 fields I need to search.

Regards
John

#2

On 10/13/2010 7:37 AM, John wrote:

Quote:

Hi

SELECT * FROM TABLE123 WHERE FULLNAME LIKE 'RED'

The above will only check one variable FULLNAME.

Is there anyway of searching across all fields in the row without listing
each variable?

There could be over 100 fields I need to search.

Regards
John

No, but if you have to search over 100 fields, I strongly suspect your
database design is not well optimized.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

#3

On 13 Oct, 12:37, "John" <john1... (AT) yahoo (DOT) com> wrote:

Quote:

Hi

SELECT * FROM TABLE123 WHERE FULLNAME LIKE 'RED'

The above will only check one variable FULLNAME.

Is there anyway of searching across all fields in the row without listing
each variable?

There could be over 100 fields I need to search.

Regards
John

For a start FULLNAME LIKE 'RED' is equivalent to FULLNAME = 'RED'

Maybe you are looking for FULLTEXT searching, but as Jerry points out,
the design certainly seems questionable.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

searching across all fields in a row

comp.databases.mysql comp.databases.mysql

searching across all fields in a row - 10-13-2010 , 06:37 AM

Re: searching across all fields in a row - 10-13-2010 , 07:42 AM

Re: searching across all fields in a row - 10-14-2010 , 04:04 AM