List:General Discussion« Previous MessageNext Message »
From:門田 祐輔 Date:October 14 2009 7:14am
Subject:Re: escape quotes
View as plain text  
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

Thread
escape quotesLex Thoonen14 Oct
  • Re: escape quotes門田 祐輔14 Oct
  • Mysql service will not stopBryan Cantwell14 Oct
    • Re: Mysql service will not stopMichael Dykman14 Oct
Re: Mysql service will not stopBryan Cantwell14 Oct