advanced code snippet search

Posted By

zachharkey on 02/26/09


Tagged

drupal


Versions (?)

Search/Replace dev environment strings (e.g. filepath) on database

 / Published in: XHTML
 

URL: http://www.slideshare.net/srhaber/drupal-wbr

Nice tip for doing global search/replace on database, taken from the excellent warner brothers records writeup.

Expand | Embed | Plain Text 
  1. UPDATE files SET filepath = REPLACE(filepath, 'mutemath.wbrdev.com', 'mutemath');
  2. UPDATE system SET filename = REPLACE(filename, 'mutemath.wbrdev.com', 'mutemath');

Report this snippet  

You need to login to post a comment.