[thelist] generating output from select statement.

[Dan McCullough]

Ahhh yes the ` instead of ' always forget that.


On Tue, 01 Feb 2005 03:46:25 +1100, Michael Pemberton
<evolt at mpember.net.au> wrote:
> Dan McCullough wrote:
> > been looking all over for this, and somehow I seem to be missing it.
> > select record1","record3","record2","record8","record4","record6","record10
> > from dealer where email not like 'test at test.com';
> 
> Try:
> 
> SELECT
>   `record1`,`record3`,`record2`,`record8`,
>   `record4`,`record6`,`record10`
> FROM dealer
> WHERE `email` <> 'test at test.com';
> 
> You will see that the field names use ` instead of ' or " to wrap them.
> 
> --
> Michael Pemberton
> evolt at mpember.net.au
> 
> --
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>