WordPress MU

Hello,

My apologies for my newbie db skills.

I would like to globally disable pingbacks/trackbacks for all my blogs via phpMyAdmin, but I can't seem to get the MySQL statement right. The statement below works on a single blog, but how can I write my query to update all "wp_blog#_posts" table across my whole db?

UPDATE wp_posts SET ping_status = 'closed';

I haven't had any luck trying to wildcard the blog number inside the wp_posts table name.

Thanks in advance.

I'd like to disable pingbacks for my entire wpmu too, prefereably thru an option somewhere instead of editting the tables manually.

Not sure if you can do wildcards in a table name in a query in mysql.

A different approach would be to write a plugin that gets a count of blogs, then does a for loop with the increment of the loop being number for the wp_blog#_posts table.

To change the default for new blogs to not have pingbacks enabled, try the New Blog Defaults plugin.