Lex Thoonen,all > UPDATE `jos_content` SET `introtext` = replace(`introtext`,"<h2 > style=\"margin: 0px 0px 5px; padding: 0px; font-family: 'Trebuchet > MS',Arial,Helvetica,sans-serif; font-weight: bold; line-height: 30px; > font-size: 30px; color: #b4b4be;\">","<h2>") > > just gives me 0 results...
How about this? UPDATE `jos_content` set `introtext` = "<h2>" where `introtext` = "<h2 style=\"margin: 0px 0px 5px; padding: 0px; font-family: 'TrebuchetMS',Arial,Helvetica,sans-serif; font-weight: bold; line-height: 30px;font-size: 30px; color: #b4b4be;\">"; (this query executed by MySQL ver 5.1.34-community) yusuke kadota -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
