little MySQL query (Boom Boom)

[concreteDonkey]

Let's pretend I have a field called "title" in a table called "person".

Table is of type ENUM with 4 options: Mr, Mrs, Miss, and Ms

I want a query that retrieves these options rather than what the rows contain?

If so How?

Thanks

 

[Argo]

SELECT DISTINCT TITLE FROM PERSON;

 

[concreteDonkey]

That's not what i wanted

The keyword DISTINCT tells SELECT to retrieve on unique rows in the resultset.

I don't want any rows, I want it to return the available options from the ENUM field title.

BTW there are no rows in the table currently, hope that helps make my question clearer

 

[akubi]

SHOW COLUMNS FROM person LIKE 'title'

 

[Argo]

So in other words you want to see all available enums from an enum type column? I don' think SQL has anything like that. You will have to go by what specific database provider has. I'm not familiar with MySQL so perhaps somebody else can answer your question.

 

[concreteDonkey]

Exactly argo, exactly.

akubi's didn't work, thanks for trying.

If anyone knows, that'd be great (I think this is a dead thread though).