Posted by cewyattjr on 11/19/67 11:46

In 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

• Next in forum: Re: ARRAY - straightforward question?
• Prev in forum: Re: running an exec in the background, let page go on.
• Thread view: Find/Replace text in content body

[Reply to this message]