[SQL] bestimmte werte ausgeben....

[Yaslaw]

Es führen viele Wege nach Rom. Hier mal 2 Ideen

SELECT 
    n.meta_value AS nickname,
    ac.meta_value AS admin_color
FROM
    wp_usermeta AS n
    INNER JOIN wp_usermeta AS ac
        ON n.user_id = ac.user_id
WHERE 
    n.meta_key = 'nickname'
    AND ac.meta_key = 'admin_color'

oder

SELECT 
    MAX(IF(meta_key = 'nickname', meta_value, NULL)) AS nickname,
    MAX(IF(meta_key = 'admin_colo', meta_value, NULL))  AS admin_color
FROM
    wp_usermeta