WordPress数据库维护代码

//更新密码
UPDATE wp_users SET user_pass = MD5('PASSWORD') WHERE user_login = 'admin'
//删除垃圾评论
DELETE FROM wp_comments WHERE comment_approved = '0';
//文章内容批量替换
UPDATE wp_posts SET post_content = replace( post_content, 'string_to_find', 'string_to_replace' ) ;