How to create such a request for deletion?

Question

SQL

There is an xfields column.
Everything that comes after ||movie_id should be removed from it, including ||movie_id.

Answer 1

SELECT SUBSTRING_INDEX('some-text||movie_id,bla-bla', '||movie_id', 1) AS xfields;

Answer 2

https://codepen.io/Geyan/pen/gWXorN there are of course a lot of shortcomings, but if you wish, they can be finalized