WordPress.org

Ready to get started?Download WordPress

Forums

MySQL Query For Emails (3 posts)

  1. ribose
    Member
    Posted 8 years ago #

    I have several blogs installed in one database, how can I run a mysql query that will output all the email adresses of the authors?

  2. ribose
    Member
    Posted 8 years ago #

    No ideas?

  3. MichaelH
    Member
    Posted 8 years ago #

    You could use

    SELECT user_email FROM wp_users;

    where wp_users is the name of user table and you'd have to replace the wp_ with the Prefix for each blog.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags