[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