Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Find/Replace text in content body
May 1, 2006, 11:14 am
rate this thread
'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?
Re: Find/Replace text in content body
set [field_name] = replace(
dunno if this one really works...