Michael Gaigg: Über UI/UX Design

4Mar0

Using REPLACE in a SQL UPDATE

Posted by Michael Gaigg

When moving domains there will be a need to replace old url's and other strings to reflect the new names.

In my case the images of my blog articles were still pointing to the old domain which didn't physically exist anymore. Result: broken images and links.

Quick Solution

A quick SQL replace does the trick:

UPDATE blog_posts SET post_content = REPLACE(post_content, 'old-server.com', 'new-server.com') WHERE post_content LIKE '%old-server.com%'

This SQL statement is perfect for updating wordpress blogs that moved to a different domain/host.

Easy and efficient 🙂

16Jul0

Highlights of Week 28/2011

Posted by Michael Gaigg

7Jun0

Highlights of Week 22/2011

Posted by Michael Gaigg

14Mar0

Highlights of Week 10/2011

Posted by Michael Gaigg

18Feb0

“Buzz this” for WordPress integration

Posted by Michael Gaigg

Google Buzz

Google Buzz

Christina Warren wrote a really nice blog entry on HOW TO: Integrate Google Buzz Into Your WordPress Blog, this will certainly get you started with your own buzz this icon/button.

I installed Google Buzz Button plugin (by Internet Techies) that allows you to add a “Buzz This” button to each of your WordPress posts (download google buzz plugin).
Yes, that's the nicely colored button right below these words - try it out, right here, right now 😉