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

        '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


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: