Here some\u00a0Some useful mySql Query for WordPress database you shold know while working on WordPress database project.<\/p>\n
As you work on your blog, your database transactions pile up overheads which can be a performance hog. To clear such overheads and optimize your database, use this query:<\/p>\n
OPTIMIZE TABLE \u2018wp_posts\u2019;<\/p><\/blockquote>\n
<\/h3>\n
Transfer Posts From One User to Another<\/h3>\n
If you wish to transfer posts and articles attributed to one user account to another account, you can use the following query (you\u2019ll need the usernames of both the accounts):<\/p>\n
UPDATE wp_posts SET post_author=NEW_AUTHOR_ID WHERE post_author=OLD_AUTHOR_ID;<\/p><\/blockquote>\n
Bulk Delete Comments<\/h3>\n
You can use this query to delete all unapproved comments.<\/p>\n
DELETE FROM wp_comments WHERE comment_approved=\u20190\u2019;<\/p><\/blockquote>\n
Disable All Plugins<\/h3>\n
Perhaps you\u2019ve accidently activated too many plugins? Or maybe you wish to make certain changes to your website and would like to disable the plugins? You can use the following query to disable all the plugins on your WP website:<\/p>\n
UPDATE wp_options SET option_value=\u2019 \u2018 WHERE option_name=\u2019active_plugins\u2019;<\/p><\/blockquote>\n
Disable Comments on Older Posts<\/h3>\n
If you wish to close comments on posts older than a specific date (say, May 5th 2012), use the following query:<\/p>\n
UPDATE wp_posts SET comment_status=\u2019closed\u2019 WHERE post_date<\u20192012-05-05\u2032 AND post_status=\u2019publish\u2019;<\/p><\/blockquote>\n
Change Username<\/h3>\n
If you wish to change the username of a given user (say, \u2018abcdef\u2019), use this query:<\/p>\n
UPDATE wp_users SET user_login=\u2019New-username\u2019 WHERE user_login=\u2019abcdef\u2019;<\/p><\/blockquote>\n
Change Default Administrator Name<\/h3>\n
UPDATE p_users SET user_login = ‘NewName’ WHERE user_login = ‘Admin’;<\/p><\/blockquote>\n
How To Change SITE URL\u00a0 And HOME URL<\/strong><\/h3>\n
update wp_options set option_value =\u2019http:\/\/yourwebsiteurl.com\u2019 where option_name=\u2019siteurl\u2019 or option_name =\u2019http:\/\/yoursiteurl.com\u2019;<\/p><\/blockquote>\n
Change Image Path Only In Post Content<\/h3>\n
update wp_posts SET post_content = REPLACE (post_content, ‘src=”http:\/\/www.oldsit.com’,’src=”<\/a>http:\/\/newsite.com’<\/a>);<\/p><\/blockquote>\n
The above query only change the source of images not the attachments available with that post, So issue the following query also along with the above one.<\/p>\n
UPDATE wp_posts SET guid = REPLACE (guid,'http:\/\/www.oldsite.com<\/a>','http:\/\/newsite.com<\/a>') WHERE post_type = 'attachment';<\/code><\/p><\/blockquote>\nReset Password<\/h3>\n
Ever wanted to reset your password in WordPress, but cannot seem to use the reset password section whatever the reason?<\/p>\n
UPDATE<\/code>wp_users <\/code>SET<\/code>user_pass = MD5( <\/code>'new_password'<\/code>) <\/code>WHERE<\/code>user_login = <\/code>'your-username'<\/code>;<\/code><\/p><\/blockquote>\nTransfer posts from one user to another<\/h3>\n
\nUPDATE wp_posts SET post_author=NEW_AUTHOR_ID WHERE post_author=OLD_AUTHOR_ID;<\/pre>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"Here some\u00a0Some useful mySql Query for WordPress database you shold know while working on WordPress database project. Optimize the Database As you work on your blog, your database transactions pile up overheads which can be a performance hog. To clear such overheads and optimize your database, use this query: OPTIMIZE TABLE \u2018wp_posts\u2019;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[388,387],"class_list":["post-824","post","type-post","status-publish","format-standard","hentry","category-wordpress","tag-mysql-query-for-wordpress","tag-some-useful-mysql-query-for-wordpress-database"],"_links":{"self":[{"href":"https:\/\/www.santoshkori.com\/blog\/wp-json\/wp\/v2\/posts\/824","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.santoshkori.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.santoshkori.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.santoshkori.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.santoshkori.com\/blog\/wp-json\/wp\/v2\/comments?post=824"}],"version-history":[{"count":4,"href":"https:\/\/www.santoshkori.com\/blog\/wp-json\/wp\/v2\/posts\/824\/revisions"}],"predecessor-version":[{"id":831,"href":"https:\/\/www.santoshkori.com\/blog\/wp-json\/wp\/v2\/posts\/824\/revisions\/831"}],"wp:attachment":[{"href":"https:\/\/www.santoshkori.com\/blog\/wp-json\/wp\/v2\/media?parent=824"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.santoshkori.com\/blog\/wp-json\/wp\/v2\/categories?post=824"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.santoshkori.com\/blog\/wp-json\/wp\/v2\/tags?post=824"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}