Find/Replace text in content body

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
In 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?



Re: Find/Replace text in content body

Found this suspicious replace function far [1] away from official mysql

update [table_name]
set [field_name] = replace(

dunno if this one really works...


Re: Find/Replace text in content body

Works GREAT!

Site Timeline