I am while using following code to create a listing of wordpress blogs during my wordpress mu network:

    $blogs = $wpdb->get_results("SELECT * FROM " . $wpdb->blogs . " WHERE last_updated!='0000-00-00 00:00:00' AND public='1' AND spam = '0' AND deleted ='0' ORDER BY registered " . $order . " LIMIT " . $limit);

How do you do in order to organize them alphabetically rather than by once they were registered? If you're not familliar using the database layout of wordpress, i'd be pleased with a coneptual explanation! The title isn't registered within the same database, this really is the way the blogname is collected for output:

foreach ($blogs as $blog) {
$blog_options = "wp_" . $blog->blog_id . "_options";
$blog_name = $wpdb->get_col("SELECT option_value FROM " . $blog_options . " WHERE option_name='blogname'");
        }

Not understanding the WordPress database schema:

If there's a distinctive blog ID both in the $wpdb->blogs table and also the $blog_options table, you are able to join together, like so (pseudocode):

SELECT [...]
FROM $wpdb->blogs a
LEFT JOIN (SELECT id, option_value AS blogname FROM $blog_options WHERE option_name='blogname') b ON a.id = b.id
WHERE last_updated!='0000-00-00 00:00:00' AND public='1' AND spam = '0' AND deleted ='0' ORDER BY blogname [... etc ...]

Within this query, you've became a member of each blog towards the connected blog_option record with optionname='blogname'. The interior query within the JOIN returns the choice_value using the alias 'blogname', to ensure that you are able to reference it inside your ORDER BY clause.

You will need to use that question a little in line with the actual database schema, but hopefully it is a start!

Based on the wordpress documentation, You cannot sort wordpress-blogs on the multi-blog-network only using SQL, because of the database-structure.