Support » Networking WordPress » how to get the (blogid, blogurl, blogname) tuples of WPMU using sql query?

  • 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:)

Viewing 1 replies (of 1 total)
  • 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).

Viewing 1 replies (of 1 total)
  • The topic ‘how to get the (blogid, blogurl, blogname) tuples of WPMU using sql query?’ is closed to new replies.