mysql Select AS

Question

241 views Asked by André Alçada Padez At 06 February 2011 at 18:36

i need to do the following select:

select distinct type as option from pages

but i keep getting errors. Can you help me please?

There are 1 answers

**codaddict** · Accepted Answer · 2011-02-06 18:37:30

codaddict On 06 February 2011 at 18:37 BEST ANSWER

Enclose it in back-ticks or use a different non-reserved-word alias.