To execute an SQL update statement in WordPress, you first need to create a new PHP file and include the WordPress core files – which will contain the database connection and the definition of the $wpdb object. Here is an example:
<?php
// 引入WordPress的核心文件
require_once( dirname( __FILE__ ) . '/wp-load.php' );
// 执行更新操作
global $wpdb;
$table_name = $wpdb->prefix . 'my_table'; // 获取表名
$data = array( 'name' => 'New Name', 'email' => 'new@email.com' );
$where = array( 'id' => 1 );
$wpdb->update( $table_name, $data, $where );
// 检查是否有错误
if ( $wpdb->last_error ) {
echo $wpdb->last_error;
}
