Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
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 ( [id://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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://202968]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (6)
As of 2024-04-23 10:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found