mysql Select AS

257 Views Asked by At

i need to do the following select:

select distinct type as option from pages

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

1

There are 1 best solutions below

0
On BEST ANSWER

option is a MySQL reserved word.

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