[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