php, how to search and replace in mysql database?

Question

i am trying to search my database for the string some text here and replace it with some text here

basically find the first  then find the first character and place it in front of the 

maybe use something like here

is this complex enough? :)

thanks

possible duplicate of [php/mysql search and replace a parts of a sentence](http://stackoverflow.com/questions/5471767/php-mysql-search-and-replace-a-parts-of-a-sentence) — Shakti Singh, Jun 08 '11 at 06:17

score 2 · Accepted Answer · edited May 23 '17 at 12:04

There is no regexp replace support in MySQL so you'll have to do the replacing in PHP and then do the update (or implement some sort of UDF for MySQL, see How to do a regular expression replace in MySQL?).

In PHP you'll use something like (after fetching all rows into a $rowset):

foreach($rowset as $row) {
  $replacement=preg_replace('/<strong>(.)/','\1<strong>',$row->fieldname,1);
  myDBCall('update mytable set myfield="'.$replacement.'" where someid='.$row->someid);
}

score -1 · Answer 2 · answered Jun 08 '11 at 06:14

-1

You would use something like:

update `table` set `fieldname` = replace(`fieldname`,'string_to_find','string_to_replace_with')

answered Jun 08 '11 at 06:14

Latox

4,655
15
48
74

php, how to search and replace in mysql database?

2 Answers2