I have 1 field to update in Mysql database
table -> wp_usermeta
field -> meta_key: _ywpar_user_total_points
field -> meta_value: 4000
The update statement: UPDATE
wp_usermeta` SET `meta_value`= 15 WHERE `user_id`= 1 and `meta_key`="_ywpar_user_total_points"
I've already tried a bunch of code from Wordpress codex and Youtube and others website, like:
global $wpdb;
$wpdb->query
("
UPDATE $wpdb->wp_usermeta
SET meta_value = 7000
WHERE user_id = 1
AND meta_key = '_ywpar_user_total_points'
");
global $wpdb;
$wpdb->update(
'wp_usermeta',
array(
'meta_value' => 4000,
),
array(
'meta_key' => '_ywpar_user_total_points', 'user_id' => 1
),
array(
'%s', // value1
'%d' // value2
),
array( '%d' )
);
none of them are working