Basic update statement

[R C]

Hello,

My apologies for my newbie db skills here.

I have a Wordpress mutliuser site and I would like to globally disable pingbacks/trackbacks for all my blogs via phpMyAdmin, so I need to run this statement on the entire db:

UPDATE wp_posts SET ping_status = 'closed';

The problem is that each 'wp_posts' table is uniquely named based on the blog id, so for example 'wp_23_posts' for blog ID 23, and so on.

I've tried to wildcard 'wp_blog#_posts' a few different ways but can't seem to get it to work.

Any suggestions would be greatly appreciated.

Thanks!

RC