Thursday, 06 November 2008

Search and Replace

Fri 07 Nov 08 00:00 Attention: open in a new window. PDF | Print | Email Tips and Tricks Brian Teeman

correcting textThis post is here because in the last 3 weeks I must have googled for the answer about 5 times.

How do you search and replace a word in a database using phpMyAdmin?

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

So if I wanted to change every occurance of "joomla" to "Joomla!" in the articles of this site I would use the query window of phpMyAdmin and type

UPDATE jos_content SET introtext=REPLACE(introtext,'joomla','Joomla!');




The final blue screen of death

Thu 06 Nov 08 00:00 Attention: open in a new window. PDF | Print | Email Lost and Found Brian Teeman

Blue screen of deathMy birthday is November 1st, and it's always been fun to keep a track of famous events that happened on that day. This year I can add the end of the Microsoft Windows 3.11 to that list.

After 15 years you might have expected the first successful GUI for non Apple users to have quietly passed away some time ago.

And yet despite the end of Windows 95 many years ago, good old WfW found a marketplace in the embedded systems market, several airlines used it to power their in-flight entertainment systems.

To honour the end of 3.11 here is my favourite Blue Screen of Death.

blue screen of death t-shirt