Basic update statement
Posted by:
R C
Date: June 12, 2009 09:52AM
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
Subject
Written By
Posted
Basic update statement
June 12, 2009 09:52AM
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.