WP中有用的SQL
Posted on Tue 27 July 2010 in WordPress
修改访问地址
UPDATE wp_options SET option_value = 'http://localhost/wordpress/' WHERE option_name ='home'; UPDATE wp_options SET option_value = 'http://localhost/wordpress/' WHERE option_name ='siteurl';
自己修改固定链接:
mysql> charset utf8 Charset changed -- 显示文章标题和固定链接信息： mysql> select id, post_title, post_name from wp_posts where post_status='publish'; -- 显示包含非ascii字符的固定链接信息： mysql> select id, post_title, post_name from wp_posts where post_status='publish' and post_name like '%%%'; -- 更新固定链接 UPDATE wp_posts SET post_name = 'joke-buddhist-elective' WHERE ID =373; -- 验证一下链接生效： http://li3huo.com/?p=373 http://li3huo.com/2010/06/joke-buddhist-elective/
Reset Password
UPDATE wp_users SET user_pass = MD5( 'new_password' ) WHERE user_login = 'your-username';
Assign all articles by Author B to Author A
UPDATE wp_posts SET post_author = 'new-author-id' WHERE post_author = 'old-author-id';
Delete Revision
DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_type = 'revision'
Identify Unused Tags
SELECT * From wp_terms wt INNER JOIN wp_term_taxonomy wtt ON wt.term_id=wtt.term_id WHERE wtt.taxonomy='post_tag' AND wtt.count=0;