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 — Shakti Singh
– Shakti Singh, Commented Jun 8, 2011 at 6:17

Community · Accepted Answer · 2017-05-23 12:04:21Z

2

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);
}

edited May 23, 2017 at 12:04

CommunityBot

11 silver badge

answered Jun 8, 2011 at 7:01

Bing

7465 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Latox · Accepted Answer · 2011-06-08 06:14:41Z

-1

You would use something like:

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

answered Jun 8, 2011 at 6:14

Latox

4,70315 gold badges51 silver badges75 bronze badges

Collectives™ on Stack Overflow

php, how to search and replace in mysql database?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related