MySql find & replace

Get in touch

If you would like help with MySql find & replace or with any other topic then feel free to get in touch for a chat.

by | 13/09/2011 | Code Snippets, Tutorials | 0 comments

Having recently moved the blog from wearekuiper.com to wearekuiper.com I discovered that the images within the posts were now broken, I could manually go through each post and reattach the images but performing a find and replace on the MySql database would be a much quicker way of getting things back on track.

 
update [table_name] set [field_name] = replace([field_name],
'[string_to_find]','[string_to_replace]');

Premium Themes & Plugins

When you sign a website up for any of our monthly plans you get access to many of our favourite premium plugins and themes — at no additional charge. Savings up to £250 per year!

Gravity forms, Create stunning forms with ease.
~£43 per year.

Optimise Images, Website Cache, Security and more.
~£136 per year.

Add a range of extra tools to your Divi Website.
~£42

Backup your website to Google or Dropbox with ease.
~£54

Backup your website to Google or Dropbox with ease.
~£80 per year

K

Newsletter

Sign up to our newsletter for the latest hints tips & offers.

Did you know nearly 70% of people unsubscribe from email lists because they receive emails too often? That’s why we often don’t get round to sending a newsletter but when we do make sure its worth reading.

  • What’s happening with us and the internet/digital in general. 
  • Lots of helpful advice on a whole range of website and digital skills topics.
  • Sales and offfers from us and our partners.