Request to update table?

Question

SQL

Hello, tell me how to write a query so that it would be possible to delete some data in the table, here is an example

[:UA]NEWS[:RU]NEWS[:EN]NEWS[:]

The test between shortcodes can be different, somehow I need to delete it so that only NEW is left, that is, the text between

[:UA]NEW[:RU]

Is it possible to make a query like this

Answer 1

In MySQL it is possible via REGEXP_SUBSTR .
But in general, this storage format creates a lot of problems. Change to a normal table (string_id, language_id, string).