UPDATE pages SET icon_image = REPLACE(icon_image, '<a target="_blank" href="https://example.com">https://example.com</a>', '<a target="_blank" href="https://tools.example.com">https://tools.example.com</a>') WHERE icon_image LIKE '<a target="_blank" href="https://example.com%">https://example.com%</a>';
here you change all the link like
<a target="_blank" href="https://tools.yoblogger.com/assets/img/nastuh.jpg">https://example.com/assets/img/nastuh.jpg</a>
<a target="_blank" href="https://tools.yoblogger.com/assets/img/nastuh.jpg">https://example.com/assets/img/nastuh.jpg</a>
to
<a target="_blank" href="https://tools.yoblogger.com/assets/img/nastuh.jpg">https://tools.example.com/assets/img/nastuh.jpg</a>

UPDATE pages SET icon\_image = REPLACE(icon\_image, '[https://example.com](https://example.com)', '[https://tools.example.com](https://tools.example.com)') WHERE icon\_image LIKE '[https://example.com%](https://example.com%)';

here you change all the link like

[https://example.com/assets/img/nastuh.jpg](https://tools.yoblogger.com/assets/img/nastuh.jpg)

[https://example.com/assets/img/nastuh.jpg](https://tools.yoblogger.com/assets/img/nastuh.jpg)

to

[https://tools.example.com/assets/img/nastuh.jpg](https://tools.yoblogger.com/assets/img/nastuh.jpg)

change only domain "https://example.com/assets/img/tools/javascript-beautifier.svg" to "https://tools.example.com" in mysql