Skip to content

kenops

Tag: sql

mySql search and replace within a field.

When moving wordpress sites from one domain to another, it’s common to have hard coded urls in the database of the old web site.  To update the majority of the posts, you can use the following sql statement to update the post urls.  You may also need to run the statement on the guid foild… Continue reading mySql search and replace within a field.

Published May 19, 2009
Categorized as Techie Tagged Scripts, sql

Categories

  • Apple
  • Fun
  • General Interests
  • iPhone
  • OSX
  • Techie
  • Travel
  • Uncategorized
  • Unix

Archives

  • April 2025
  • March 2025
  • June 2024
  • May 2023
  • October 2022
  • September 2022
  • August 2022
  • January 2021
  • October 2020
  • June 2020
  • June 2017
  • March 2017
  • September 2011
  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • December 2008
  • September 2008
  • June 2008
  • February 2008

Pictures

kenops
Proudly powered by WordPress.