How to delete a row in a table using only the beginning and end of the text?

Question

MySQL

There is a dle_post table and a descr column with a description of the news, in all descriptions there is a line that is repeated, but inside it the product name is different.
Example:

We bake the best cherry bread in the country.

This phrase is repeated in all the news, only the name " Cherry " changes.
An example in the screenshots, now like this:

And you need to do this:

What sql query is needed to remove a line along with the title from all news?

Answer 1

Just use the LIKE operator

delete from news where description like 'Мы печем лучший % хлеб в стране.';

SQL LIKE online