SQL to Update Custom Field

Up until now, you’ve been getting data out of the database. It’s time to update data in the database. You’ll learn about how to update custom fields in the wp_postmeta database table both by writing the native SQL and using update function from WordPress Core.

First, let’s write the SQL to change the custom field’s value in the database. You’ll learn about the UPDATE keyword in SQL.

Then let’s update the subtitle using update_post_meta(). When you run the following code, the subtitle changes and then renders out to the browser. You’ll look at the SQL queries WordPress generates via the plugin, Query Monitor.