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


Solution:

If you know the solution of this issue, please leave us a reply in Comment section, to update the question.


Wordpress related questions and answers: