L
L
LebedevStr2016-10-23 23:09:00
MySQL
LebedevStr, 2016-10-23 23:09:00

How to use regular expression in SQL query?

Hello. There is a request

UPDATE ИМЯ_ТАБЛИЦЫ SET ИМЯ_ПОЛЯ = REPLACE(ИМЯ_ПОЛЯ, 'строка для замены', 'чем заменяем');

It is necessary that under the "string to replace" such values ​​would fall into
the text I want#this-that-text-remove The
request should remove
#this-that-text-remove
and leave
the text I want.
Remove everything after the "#", along with the hash.
In general, I don’t understand anything about muscle. Tell me please.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question