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 !