William Eaton - Scripts & Function

replace string in a table

If you want to change certain rows in a database where a query applies … for example an “if” query finding all entries which contain “samplesearchtext”… then run the following script either via mysql/phpmyadmin/php

update mytable set myfield =replace (myfield, ’samplesearchtext’, ’samplereplacetext’);