[thelist] [CFMX] How to implement a search feature?
Raymond Camden
jedimaster at mindseye.com
Thu Jun 19 13:12:12 CDT 2003
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 !
More information about the thelist
mailing list