Find/Replace text in content body

n a mediumtext field I have many instances of a URL, eg:
‘’ 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?


select id, fulltext from content LIKE ‘%’

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?



Leave a Reply

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