M
M
metya2014-01-12 23:32:29
MySQL
metya, 2014-01-12 23:32:29

how to replace url address in mysql wordpress?

There is a string content in the database like "something http:/\/\ptu something" .
I don't know why it's written that way. But when looking for something like this

SELECT *
FROM table
WHERE value LIKE '%http:/\/\ptu%'

The result produces zero lines, although it is exactly written there like this. Accordingly, this line cannot be replaced, since the search simply does not find this value.
The regular expression is easy to find the value, but I don't know how to use the regular expression replacement.

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