How to bulk replace title?

Question

WordPress

WP site, how to bulk replace the 1st word in the title.
.....1000.... must be replaced by ....100...

Answer 1

Hello!
For example, using the search regex plugin. He knows how to search with the help of a regular expression.
You can search for something like:
^1000
and replace with:
100

Answer 2

Probably so:

UPDATE `sometable`
SET `somefield` = REPLACE(`somefield`, '1000', '100')
WHERE 1