[thelist] [CFMX] How to implement a search feature?

[Raymond Camden]

This just occured to me - could you not do

select col1 + col2 + col3 as main
from foo
where main like 'a' or main like 'b'

etc

It may make it a bit easier.

========================================================================
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email    : jedimaster at mindseye.com
Blog     : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org 
> [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Chris Johnston
> Sent: Thursday, June 19, 2003 10:05 AM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] [CFMX] How to implement a search feature?
> 
> 
> 
> >
> >> 2. I know in sql you can do a search using like and the wildcard 
> >> character. Is there a way of doing this with a list.
> >>
> >> i.e. select * from foo where col in ('%word1%', '%word2%', etc...)
> >>
> >> and have it act in the same manner as using like?
> >
> > Not that I know of.  You'd be better off though using full 
> text search 
> > anyway.  Full text search is available in MS SQL and Sybase 
> ASE I know 
> > and I think its available in MySQL and PostGres now.  Its 
> really build 
> > for what you want to do.  If you tell us your DB we can probably 
> > provide some pointers to resources.
> 
> This sounds cool, the DB that I am using is MySQL 4 (I believe).
> 
> Am I right to assume that if I want to do the search on 
> multiple columns then I would have to do something like this
> 
> select * from table where col1 like '%word1%' or col2 like 
> '%word2%' or col2 like '%word1%' or col2 like '%word2%'
> 
> 
> Assuming I don't use full text search?
> 
> OR would using Veritas for my search be easier?
> 
> -- 
> Chris Johnston
> 
> chris at fuzzylizard.com
> www.fuzzylizard.com
> -- 
> * * Please support the community that supports you.  * * 
http://evolt.org/help_support_evolt/

Evolt.org conference in London, July 25-27 2003.  Register today at
http://evolt.org.uk

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt !