Mysql How to delete from character to character?

Question

MySQL

There is a record, it has data that is between these characters

<!--leech_begin--> тут данные которые нужно удалить <!--leech_end-->

How to do it?

Answer 1

update table_name
set = ''
where column_name

Answer 2

Try using SUBSTRING_INDEX and concatenation.