Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

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

by screamingeagle (Curate)
on Oct 05, 2002 at 01:55 UTC ( #202968=note: print w/ replies, xml ) Need Help??


in reply to 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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://202968]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (8)
As of 2015-07-31 02:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (274 votes), past polls