In a SQL prompt you could do UPDATE [table_name] SET [field_name] = REPLACE([field_name],'[string_to_find]','[string_to_replace]'); Replace the [stuff] including the [] with the tables you want to effect and the fields... So UPDATE node_revisions SET body = REPLACE(body, Red¹, Blue¹); Would replace all Reds with Blues in the table node_revisions and the field body. BACK YOUR DATABASE UP BEFORE YOU TRY THIS! -- Mike Bishop Digital Mercenary ADAMSON ADVERTISING P. 314.727.9500 x 1237 M. 314.537.6723 From: sessy <sessy@citromail.hu> Reply-To: <support@drupal.org> Date: Wed, 13 Jun 2007 23:45:33 +0000 To: <support@drupal.org> Subject: Re: [support] Search and Replace A fast solution is to dump the database into an .sql file, and do a search&replace on it. Another method would be to do a mysql update using the replace function: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replac e regards, s Wed, 13 Jun 2007 10:17:30 -0400 -n "A-NO-NE Music" <madflute@anonemusic.com> írta:
I finally made the site live last night by modifying htaccess, only to find path written in node bodies are all wrong. Where it says: src/href="sites/.. It should had said: src/href="/sites/..
There are million places I have to edit. How can I do this Search and Replace in one shot? -- [ Drupal support list | http://lists.drupal.org/ ]