Replace with a double quote in the texte

ok my line :

UPDATE table SET field = replace(field,"<div class='"subtitle"'>","<P>")

I want to replace

<div class='"subtitle"'> by <p>

how can I modify the quote in “subtitle” to make the replace work?


What database are you using?


UPDATE table SET field = 
REPLACE(field,'<div class=''"subtitle"''>','<P>')

will work in all databases

note two consecutive single quotes to represent one is standard SQL escape seqeunce

even mysql with its funky you-can-use-either-'-or-"-to-delimit-strings and its wacky backslash escape character will execute it successfully