Skip to content

Instantly share code, notes, and snippets.

@bilalmalkoc
bilalmalkoc / get_meta_values.php
Created August 4, 2018 13:15 — forked from tybruffy/get_meta_values.php
Get all distinct values of a meta field in Wordpress
function _get_all_meta_values($key) {
global $wpdb;
$result = $wpdb->get_col(
$wpdb->prepare( "
SELECT DISTINCT pm.meta_value FROM {$wpdb->postmeta} pm
LEFT JOIN {$wpdb->posts} p ON p.ID = pm.post_id
WHERE pm.meta_key = '%s'
AND p.post_status = 'publish'
ORDER BY pm.meta_value",
$key