mysql Select AS

Question

i need to do the following select:

select distinct type as option from pages

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

Answer 1

option is a MySQL reserved word.

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