How to replace part of text in mysql?

Question

PHP

There is table content

html code
<table>
htm code2
</table>

you need to replace only с <table> до </table>inclusive
html code at the top you need to leave
now I replace it like this

$sql = "UPDATE wp_posts SET post_content='$zamena' WHERE ID='2379'";

replaces completely