Search and replace PHPMYADMIN

UPDATE `your_table_name` SET `your_field_name` = replace(your_field_name, 'text you want to find', 'text you want to replace')

EG.

UPDATE `node__body` SET `body_value`=replace(body_value, 'href="/evidence/', 'href="/resources/')
UPDATE `node__body` SET `body_value`=replace(body_value, 'href="/evidence', 'href="/resources')
UPDATE `node__body` SET `body_value`=replace(body_value, 'href="http://mamaye.org/evidence/‘, 'href="http://mamaye.org/resources/')
UPDATE `node__body` SET `body_value`=replace(body_value, 'href="http://mamaye.org/evidence', 'href="http://mamaye.org/resources')