Re: DBI - Multi-field SQL: *OR* condition w/o specifying field names...possible?

AFAIK, neither SQL Server nor Oracle supports the syntax (...* LIKE '%sean%' ) you're trying to use. (I'll go as far as saying no well-known DBMS supports this syntax)

Comment on Re: DBI - Multi-field SQL: OR condition w/o specifying field names...possible? Download Code

Replies are listed 'Best First'.
Re: Re: DBI - Multi-field SQL: OR condition w/o specifying field names...possible? by S_Shrum (Pilgrim) on Oct 05, 2002 at 05:29 UTC
Do you know if there is another way to do this sort of search in SQL without specifying column names? After reading the posts that I got I think I may have to look for a full text search tool or do something like writting my own where I load the file into a array and filtering out the records that don't contain the text and passing the resulting array to my content engine which uses DBI as the page construction engine. Oh well...thanks for the insight. ====================== Sean Shrum http://www.shrum.net	[reply]

Replies are listed 'Best First'.

Re: Re: DBI - Multi-field SQL: *OR* condition w/o specifying field names...possible?
by S_Shrum (Pilgrim) on Oct 05, 2002 at 05:29 UTC

Do you know if there is another way to do this sort of search in SQL *without* specifying column names?

After reading the posts that I got I think I may have to look for a full text search tool or do something like writting my own where I load the file into a array and filtering out the records that don't contain the text and passing the resulting array to my content engine which uses DBI as the page construction engine.

Oh well...thanks for the insight.

======================
Sean Shrum
http://www.shrum.net

[reply]