Replace with a double quote in the texte

Databases
1

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?

thanks

2

What database are you using?

Cheers,
D.

3 
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