vkoser/MSSQL search and replace text in text column

Created May 4, 2010 16:22

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/vkoser/389610.js"></script>
Save vkoser/389610 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

MSSQL search and replace text in text column

 -- specifically used this to update non relative links in my mssql
 -- database for old posts after blog move
 UPDATE wp_posts SET post_content =
 REPLACE( post_content, 'http://www.kosertech.com/blog/' , 'http://www.kosertech.com/')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment