How to delete everything in the table after the specified text?

Question

MySQL

How can a base table delete everything after a word to the end of a cell?
For example, in a base cell there is a text:
"First text text text WORD second text text text" and there are many such cells in the database.
What command can go over all the cells and delete everything after the word "WORD", so that only the following remains in the cells:
"First text text text"
Please tell me. Thanks in advance

Answer 1

use the LOCATE() and SUBSTRING() functions