[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

More information about the thelist mailing list