[thelist] [CFMX] How to implement a search feature?
Chris Johnston
chris at fuzzylizard.com
Thu Jun 19 12:53:47 CDT 2003
> 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
More information about the thelist
mailing list