How to find custom field value IDs from Database

[Pavan]

Hi Team,

I have  a custom field (Single Select) with 160 values in it.

I need a database query to find all the values with their ID

Please help

Thanks,

Pavan

[Sreenivasaraju P · Accepted solution]

Hi @Pavan 

select ID,customvalue from customfieldoption where CUSTOMFIELD="your custom field id";

[Pavan]

Thanks Sreenivasaraju, it gave me what I need.

[Kevin Mowrey]

Edit: I didn't read your question thoroughly. 

Sreenivasaraju P is right. :)