{"id":2852,"date":"2012-10-31T13:59:40","date_gmt":"2012-10-31T13:59:40","guid":{"rendered":"https:\/\/silicondales.com\/?p=2852"},"modified":"2018-06-06T12:22:49","modified_gmt":"2018-06-06T11:22:49","slug":"wordpress-using-mysql-to-update-specific-custom-fields","status":"publish","type":"post","link":"https:\/\/silicondales.com\/tutorials\/wordpress\/wordpress-using-mysql-to-update-specific-custom-fields\/","title":{"rendered":"WordPress &#8211; Using MySQL to Update Specific Custom Fields"},"content":{"rendered":"<p>Some time ago, we told you <a title=\"How to Find &amp; Replace in MySQL\" href=\"https:\/\/silicondales.com\/tutorials\/mysql\/how-to-find-replace-in-mysql\/\">how to Find &amp; Replace Data using MySQL<\/a> &#8211; today I am going to explain how to use this query to update specific custom fields in WordPress databases, in bulk, on-the-fly, without having to login, open, and edit every single WordPress post you&#8217;ve got!<\/p>\n<p>Remember, before doing anything to your database, backup so you can restore if you mess things up. It is your responsibility!<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-662ce7e435a03\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0a0a0a;color:#0a0a0a\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0a0a0a;color:#0a0a0a\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-662ce7e435a03\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/wordpress-using-mysql-to-update-specific-custom-fields\/#Find_Replace_in_MySQL\" title=\"Find &amp; Replace in MySQL\">Find &amp; Replace in MySQL<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/wordpress-using-mysql-to-update-specific-custom-fields\/#Applying_This_to_WordPress_Custom_Fields\" title=\"Applying This to WordPress Custom Fields\">Applying This to WordPress Custom Fields<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/wordpress-using-mysql-to-update-specific-custom-fields\/#Update_Custom_Field_Name\" title=\"Update Custom Field Name\">Update Custom Field Name<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/wordpress-using-mysql-to-update-specific-custom-fields\/#Update_Custom_Field_Value\" title=\"Update Custom Field Value\">Update Custom Field Value<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/wordpress-using-mysql-to-update-specific-custom-fields\/#Update_Custom_Field_Value_For_Specific_Custom_Fields\" title=\"Update Custom Field Value For Specific Custom Fields\">Update Custom Field Value For Specific Custom Fields<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/wordpress-using-mysql-to-update-specific-custom-fields\/#Want_Other_Custom_Field_MySQL_Queries\" title=\"Want Other Custom Field MySQL Queries?\">Want Other Custom Field MySQL Queries?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/wordpress-using-mysql-to-update-specific-custom-fields\/#Want_us_to_Manage_or_Host_your_WordPress_Website\" title=\"Want us to Manage or Host your WordPress Website?\">Want us to Manage or Host your WordPress Website?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Find_Replace_in_MySQL\"><\/span>Find &amp; Replace in MySQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To revisit the query, this is how to find &amp; replace data in MySQL:<br \/>\n<code>update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');<\/code><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Applying_This_to_WordPress_Custom_Fields\"><\/span>Applying This to WordPress Custom Fields<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>All well and good, but how do we apply this to WordPress post custom fields? Well, the below queries will allow you to update various elements of WordPress Custom Fields. In each query, we are going to assume that your WordPress database prefix is &#8220;wp_&#8221; &#8211; alter the string to suit your needs.<\/p>\n<p>For Custom Fields, the table you want to be toggling is the &#8220;wp_postmeta&#8221; table. Using a program like PHPMyAdmin, click on that table, then hit &#8220;SQL&#8221; at the top to run queries on it.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Update_Custom_Field_Name\"><\/span>Update Custom Field Name<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><code><code>update\u00a0 set\u00a0'wp_postmeta' = replace('meta_key','[OLDKEYNAME]','[NEWKEYNAME]');<\/code><br \/>\n<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Update_Custom_Field_Value\"><\/span>Update Custom Field Value<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><code>update\u00a0 set\u00a0'wp_postmeta' = replace('meta_value','[OLDVALUENAME]','[NEWVALUENAME]');<\/code><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Update_Custom_Field_Value_For_Specific_Custom_Fields\"><\/span>Update Custom Field Value For Specific Custom Fields<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Maybe you want to replace the number &#8220;10&#8221; with the number &#8220;11&#8221; but only on the custom fields where the custom field name is &#8220;price&#8221; &#8211; below is the query you&#8217;d use for that:<br \/>\n<code>update\u00a0 set\u00a0'wp_postmeta' = replace('meta_value','[OLDVALUENAME]','[NEWVALUENAME]') WHERE 'meta_key' = 'price';<\/code><br \/>\nThe above query is really powerful, and can allow you to update many specific custom fields really quickly and easily, for example if you have a custom field referring to the URL of thumbnails, and you recently moved your domain!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Want_Other_Custom_Field_MySQL_Queries\"><\/span>Want Other Custom Field MySQL Queries?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Leave a public comment below and I will try to update the above list.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Want_us_to_Manage_or_Host_your_WordPress_Website\"><\/span>Want us to Manage or Host your WordPress Website?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Please <a href=\"https:\/\/silicondales.com\/about-us\/contact-us\/\">contact us<\/a> for a no obligation conversation and quotation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Some time ago, we told you how to Find &amp; Replace Data using MySQL &#8211; today I am going to explain how to use this query to update specific custom fields in WordPress databases, in bulk, on-the-fly, without having to login, open, and edit every single WordPress post you&#8217;ve got! Remember, before doing anything to &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"WordPress &#8211; Using MySQL to Update Specific Custom Fields\" class=\"read-more button\" href=\"https:\/\/silicondales.com\/tutorials\/wordpress\/wordpress-using-mysql-to-update-specific-custom-fields\/#more-2852\" aria-label=\"Read more about WordPress &#8211; Using MySQL to Update Specific Custom Fields\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":49512,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[15,10],"tags":[4330,420,1089,1090,1133,1268,1564],"acf":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/posts\/2852"}],"collection":[{"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/comments?post=2852"}],"version-history":[{"count":0,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/posts\/2852\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/media\/49512"}],"wp:attachment":[{"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/media?parent=2852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/categories?post=2852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/tags?post=2852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}