Find/Replace text in content body

n a mediumtext field I have many instances of a URL, eg:
‘http://myurl.com/index.php’ that I want to replace with just ‘/’

How can I write an update query that will update all instances of the
URL in all records with this field?

eg:

select id, fulltext from content LIKE ‘%http://myurl.com/index.php%’

But THEN what? I’m working with phpmyadmin, but I guess I could just
write this as a PHP script as well? Probably easier to just inject SQL
using the utility program, tho’, eh?

Thanks!

-CW

Leave a Reply

Your email address will not be published. Required fields are marked *