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?
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?