wp_users – MySql WordPress

  • PH web dev

    (@wer0ckz)


    13 years, 10 months ago

    Hi guys. I need a little help please. How can I query in phpmyadmin to display users with administrator roles only?

    Example: SELECT user_login FROM wp_users Where role=”administrator”

    That query doesn’t work. Can you help me guys how to correct the sql query?

    Thanks in advanced.

Viewing 2 replies - 1 through 2 (of 2 total)
  • s_ha_dum

    (@apljdi)

    13 years, 10 months ago

    Assuming I haven’t made a typo somewhere …

    SELECT user_login FROM wp_users LEFT JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id WHERE wp_usermeta.meta_key = 'wp_capabilities' AND wp_usermeta.meta_value LIKE '%administrator%'
    Thread Starter PH web dev

    (@wer0ckz)

    13 years, 10 months ago

    thank you so much! it worked!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘wp_users – MySql WordPress’ is closed to new replies.