[thelist] generating output from select statement.

Michael Pemberton evolt at mpember.net.au
Mon Jan 31 10:46:25 CST 2005


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




More information about the thelist mailing list