You can run the following sql queries:
update wp_postmeta set meta_key=replace(meta_key,'MyCustomHeader','_MyCustomHeader') where meta_key like "MyCustomHeader";
update wp_postmeta set meta_key=replace(meta_key,'MyCustomTitle','_MyCustomTitle') where meta_key like "MyCustomTitle";
Related Posts:
- Why WordPress choose data serialization over json_encode?
- Dealing with Many Meta Values, 30+
- What is the most secure way to store post meta data in WP?
- How to delete outdated, wrongly sized images in _wp_attachment_metadata?
- Meta query interfering with orderby relevance
- Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
- How to solve slow WordPress site caused by attachment_metadata
- Delete all post meta except featured image
- Is it possible to store visitors IPs in wp_postmeta table?
- Multiple postmeta with same name for one post in wp_postmeta table
- Delete all post meta except featured image Using SQL
- One post carries 30 postmeta values, is this too much?
- delete post meta from db, even if does not exist?
- WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
- Storing data for a wordpress plugin
- Where does the actual data stored by add_post_meta
- Structure of postmeta meta_value for woocommerce product download
- Saving zero as meta value
- Uknown meta entries in wp_postmeta
- Does post_meta data need to be unserialzed?
- Link image with data from the wpdb
- Custom Post Type not showing anything added by code anymore?
- Compare User meta_value with Product meta_value
- How to save EXIF metadata in WordPress database?
- _wp_attachment_metadata is not being added to database when PDF files uploaded
- “BS_” rows in postmeta table
- Migrating meta_key and meta_value from old theme to new one
- Database structure for thousands of posts
- How much post meta data is too much?
- How do i get value from wp_postmeta?
- Recommended Post Structure for DB Storage
- SQL query : Select a thumbnail for a media
- What is the difference between an ORM and an ODM?
- Rename a table in MySQL
- How should I tackle –secure-file-priv in MySQL?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Keeping WP database synced across multiple developers using git
- Post meta vs separate database tables
- Is it possible to define two databases for one installation?
- Connect forms in WP to external database
- Hook into $wpdb
- How to get site URL if database is disconnected?
- Is it wise to delete post revisions and autosaves from database?
- Improve or optimize a very slow query
- Using two different DB users on one WP install
- Usage of Direct Database Call Without Caching Error
- Can I transfer a mysql database to another site?
- Weird issue with database migration and SSL links
- Merge two databases: OLD SITE -> NEW SITE
- Backup another database with BackUpWordPress plugin [closed]
- Easiest Way to Authenticate WP Users Using an External DB?
- How to use a different database to list and manage comments in the backend
- How to check if a core update, like 4.9.8 → 5.0, involves a database update (migration)?
- Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
- How do I find out the full path of a page’s template?
- I need to get an array from the wordpress database
- Moving minor updates between local and live sites – just database?
- Use mulitple usernames?
- Exporting table to csv works in the admin but exports HTML data when used on the front end
- wp search-replace (not executing)
- How to have an external DB read and get data from my wordpress database
- Import users from old WP site to new one
- can we add extra table or column in wordpress for adding our data
- Changing root password in PHPMyAdmin for WordPress Database when going live
- How to properly check if a table exists in WordPress Database using Show Tables Query
- Fill custom select field with pages/post titles
- Display post number by category
- Recovering the table wp_usermeta from users
- Copying blog from root to /folder (Not moving)
- How to restore an option_value with serialized data from backup data
- Replacing javascript link in WordPress database without getting mysql syntax errors
- User input to database
- What structure and database storage method should I use for temporary storage that may be written concurrently?
- how to access 2nd Mysqli Database from different server for wordpress
- Error establishing a database connection – WordPress setup, everything else is working
- Change user_nickname for author page link
- What is recommended data type and encryption type for password in a database
- How to map data on CSV to web pages?
- Database size for news publishers?
- WordPress URL error for links
- Search and Replace in Windows XAMPP site
- How to get the id of recently registered user from database?
- How can i syn wordpress user table with a stand-alone php script?
- Cloned site not connecting to database – MAMP
- How can we speed up wp_get_nav_menu_items()?
- How to use separate database on differrent server with different username and password in wordpress for users data
- Generating an HTML table from an array based on dynamic key values
- Split posts between databases
- Moving Site: Is Re-downloading Files After Changing URLs necessary?
- Why are my WordPress post queries so slow?
- Moving database from WP 2.6 to 3.5 problem
- How do I find posts?
- Multi database link and mix and match email alert
- Homepage redirects to other site of mine? [closed]
- Which is less DB intensive in the loop: custom taxonomies or meta fields?
- WordPress, Error when trying to insert data >> Notice: wpdb::prepare was called incorrectly
- Sharing plugin tables between 2 sites in the same database
- How to monitor database for uptime? [closed]
- Find specific text in the database and display the context of where that text is
- SEO impact: WP+Next.js hybrid [closed]