How to find and replace text in mysql database?

Question

MySQL

Hello. The company's phone number has changed due to moving to a new office.
The site has a lot of materials containing the old phone number. Finding all the materials and editing the phone number there will take a lot of time.
Please tell me how to do a search and replace in phpmyadmin?

Answer 1

UPDATE articles SET text = REPLACE(text, '8-927-123-45-67', '8-927-123-76-54') WHERE text LIKE '%8-927-123-45-67%'