How to stop WordPress removing line breaks

Posted in: Blog- Feb 17, 2010 2 Comments

We’ve all had these problems working with WordPress as designers where you are trying to format an article or something for a client and have everything lined up perfectly, publish the article, only to find out that WordPress has removed all your manual line-breaks! Fortunately there is a pretty simple fix, I had to edit [...]

Find & Replace in MySQL

Posted in: Blog- Oct 07, 2009 No Comments

Somewhere between the backing-up and restoration of a clients MySQL WordPress database we picked up some strange characters. Rather than having to go through by hand to edit them out, we used a nice SQL snippet to do a full-database search and replace. update [table_name] set [field_name] = replace([field_name],’[string_to_find]‘,’[string_to_replace]‘); So in this case, to get [...]