List:General Discussion« Previous MessageNext Message »
From:Lex Thoonen Date:October 14 2009 5:38am
Subject:escape quotes
View as plain text  
Hi,

I'm trying to replace this:

<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;">

but

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 do I correctly replace and unescape the quote?

Thanks!

-- 
Lex Thoonen
Pêng Smart Web Design - http://www.peng.nl
Gran Canaria Info     - http://www.gran-canaria-info.com
Hollandse Nieuwe      - http://www.hollandsenieuwe.com
tel. +34 928 88.61.77

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