MySQL Forums :: Newbie :: Basic update statement

Advanced Search

Basic update statement
Posted by: R C ()
Date: June 12, 2009 09:52AM


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.



Options: ReplyQuote

Subject Written By Posted
Basic update statement R C 06/12/2009 09:52AM
Re: Basic update statement Rick James 06/13/2009 01:12PM
Re: Basic update statement R C 06/19/2009 07:42AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.