How to text Search across all Columns

[L. D. James]

Can some tell me of a syntax to search for a text string that might be
in any column in a table. Something simular to:

SELECT * FROM mycontact WHERE * LIKE 'string';

Thanks in advance for any suggestions or comments.

-- L. James
--
--------------------------------
L. D. James
lj****@apollo3.com
www.apollo3.com/~ljames

[tom]

On Wed, 25 May 2005 07:01:01 -0400, L. D. James wrote:

Can some tell me of a syntax to search for a text string that might be
in any column in a table. Something simular to:

SELECT * FROM mycontact WHERE * LIKE 'string';

Thanks in advance for any suggestions or comments.

WHERE CONCAT(field1, field2, ... fieldn) LIKE 'string';

Don't expect this to be particularly fast.
Thomas Bartkus

[Aggro]

L. D. James wrote:

Can some tell me of a syntax to search for a text string that might be
in any column in a table. Something simular to:

SELECT * FROM mycontact WHERE * LIKE 'string';

select * from mycontact where field1 like 'string' or field2 like
'string' or field3 like 'string' ...

[L. D. James]

"Aggro" <sp**********@yahoo.com> wrote in message
news:jN***************@read3.inet.fi...

L. D. James wrote:

Can some tell me of a syntax to search for a text string that might
be
in any column in a table. Something simular to:

SELECT * FROM mycontact WHERE * LIKE 'string';

select * from mycontact where field1 like 'string' or field2 like 'string'
or field3 like 'string' ...

Thanks, Guys. I was hoping to have a cleaner method for the 93 fields.

The reference works fine.

-- L. James
--
--------------------------------
L. D. James
lj****@apollo3.com
www.apollo3.com/~ljames