I want to write update query to expire transients . I will upadte their time to 1 in wordpress option table.
I have transients starting by the name
re_compare and rest after it parameter changes.
My query for update is
$wpdb->update( 'options', array( 'option_value' => '1', // string ), array( 'option_name' => '%re_compare%' ) );
Its not working . Basically I want to remove / Expire already existing transients.
But if I delete transients from options table they still show in transient manager plugin. So thought to set their expire time to 1 second.
Read more here: How to expire a wordpress transients