PRIMERO REVISAR:
SELECT ID, post_content
FROM wppq_posts
WHERE post_content LIKE '%url:https%3A%2F%2Fcoc.ccbchurch.com%2Fgoto%2Fgiving%';


UPDATE wppq_posts
SET post_content = REPLACE(post_content, 'url:https%3A%2F%2Fcoc.ccbchurch.com%2Fgoto%2Fgiving', 'url:https%3A%2F%2Fpushpay.com%2Fg%2Fchurchofchampions')
WHERE post_content LIKE '%url:https%3A%2F%2Fcoc.ccbchurch.com%2Fgoto%2Fgiving%';