Possible to get all custom field values?

• kkyang

• August 27, 2014 at 1:15 pm

I’m looking to get all unique custom field values.

Currently I’m just looping through all posts, saving to an array, then removing dupes however I feel like there should be a better way to do this.

• VoiD2008

• August 29, 2014 at 12:30 am

$unique_non_blank_values = $wpdb->get_results( "SELECT DISTINCT meta_value FROM ".$wpdb->postmeta." WHERE meta_key = 'YourMetaKey' AND meta_value <>'' ORDER BY meta_value DESC");

maybe this way?

• kkyang

• August 29, 2014 at 8:18 am

my sql skills are non existent 😛 . I’ll try it out though! thanks!