[thelist] sql and databases

[Rob Taft]

Its looking for an instance of the ENTIRE phrase. Much like placing a
statement into quotes in a seach engine. You would have to do a 'Like'
for each part of the term. A basic  example could go as such:

like '%' johnny '%' and row_stuff like '%' cash'%' and....

A loop that builds your SQL would be good for this.

Strength and honor
- r0b

On Fri, 13 Aug 2004 12:42:32 -0700, Andrew Martin <comitque at hotmail.com> wrote:
> I am working on a site for a record store.  They have a database full of
> artist names and album titles.
> 
> Using ASP, I currently use LIKE as a sql term, so SELECT * WHERE artist LIKE
> '%" & searchterm & "%'"
> 
> If someone searches for "JOHNNY CASH AND THE FUNKY FRESH BAND" and the
> actual artist title is JOHNNY CASH WITH THE FUNKY FRESH BAND, no results
> appear.
> 
> "johnny cash funky fresh" also would not turn up any results because that
> exact phase is not in the database.
> 
> How do I perform a more complicated search?  Are there tutorials anywhere
> for this?
> 
> Thanks!
> --
> 
> News! - Evolt.org conference for web professionals.
> 17-19 September 2004 in Toronto, Canada.
> Details at http://TOevolt.org
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>