Ah, maybe then use where (col1+col2 etc) like foo? If that works, it would still be easier then where col1 = word1 or col2 = word1 or col1 = word2 etc ======================================================================== === 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 11:54 AM > To: thelist at lists.evolt.org > Subject: RE: [thelist] [CFMX] How to implement a search feature? > > > > > 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' > > > > > > It may make it a bit easier. > > > > I like this syntax, except that I tried it in phpmyadmin and > it didn't work. Kept complaining that there is not column main. > > I was doing a little reading on the mysql site and it seems > that the above concatenation and alias will only work for > select into statements. Hopefully someone can prove me wrong. > > -- > 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 !