[Resolved] How to find unique values of a custom field

[Author]

Posts

[lokeshG]

Hi,

I have a custom post with a custom field country. I have like 13000 fields in which I want to find the distinct values. What query should I create for the same?

[Nigel]

You want to find out what all of the unique values for some custom field are?

You can't readily do that with WordPress using existing functions and it's not something Toolset can do for you either.

Do you just need to do this one time so you can see what unique values have currently been stored, or is it something you will need to do often?

You need to directly query the database with MySQL for this.

If you are doing it one time only you could use phpMyAdmin or similar to run such a query.

Or if you need to do it programmatically then you can make use of the $wpdb Class that WordPress makes available for interacting directly with the database.

Here are details of that Class: https://codex.wordpress.org/Class_Reference/wpdb

You'll want to create a MySQL query that uses DISTINCT to get unique values for some post meta key.

hidden link

Here is an answer on Stack Overflow that is doing something similar to what you describe: https://stackoverflow.com/a/20293486/1180189

If you are not able to modify that according to your needs you will need to contract a developer to do it for you. They need to know WordPress, but the only thing they need to know about Toolset is that if this custom field is a Types field then it is stored in wp_postmeta with a prefix of 'wpcf-', e.g. 'wpcf-my-custom-field'.