How to get all possible values stored for a field

[dps123]

Hi, just wondering if there is a neat way to get all possible values stored for a particular field. I realise I could do this with PHP and MySQL by querying the relevant field_my_field table, but wondered if there was a better way.

[LostKobrakai]

I think the mysql variant would certainly be the most performant. Otherwise you'd need to load all pages holding that field into memory, which is probably not your intend.

[Pete Jones]

https://processwire.com/talk/topic/9400-how-to-get-all-unique-values-for-a-field/

Good discussion by LostKorakai.