Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
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
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 avoiding work at the Monastery: (6)
As of 2014-12-22 01:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (110 votes), past polls