WordPress.org

Ready to get started?Download WordPress

Forums

how to get the (blogid, blogurl, blogname) tuples of WPMU using sql query? (2 posts)

  1. skybig
    Member
    Posted 1 year ago #

    i just don't know from which data table i should query this inforamtion.

    i cannot find this information in wp_site and wp_blogs tables

    i have tried to find this information from other tables, still failed, so anybody here who knows how to get the (blogid, blogurl, blogname) tuples of WPMU using sql query?

    thank you:)

  2. ancawonka
    Member
    Posted 1 year ago #

    The URL and Blog name are in the wp_[x]_options tables, so you need to query a different table for each blog. These are the same tables that you woud query on a single site.

    blog_id comes from wp_blogs (it's the first column).

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags