WordPress.org
Get WordPress

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #24498, comment 11


Ignore:
Timestamp:
07/17/2015 02:26:34 AM (11 years ago)
Author:
rarylson

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #24498, comment 11

    initial v1  
    2727
    2828{{{
    29 SELECT UNIQUE meta_key
     29SELECT DISTINCT meta_key
    3030    FROM wp_postmeta
    3131    WHERE meta_key NOT LIKE '\_%'
    … …  
    4646     $limit = apply_filters( 'postmeta_form_limit', 30 );
    4747-    $sql = "SELECT meta_key
    48 +    $sql = "SELECT UNIQUE meta_key
     48+    $sql = "SELECT DISTINCT meta_key
    4949         FROM $wpdb->postmeta
    5050-        GROUP BY meta_key
    … …  
    5858----
    5959
    60 I'm happy that @pross (comment 10) just proposed the same patch than me.
     60I'm happy that @pross (comment 10) just proposed the same patch than me (I update the patch to use DISTICT instead of UNIQUE because DISTICT is more common).