mapleleaf Posted June 21, 2012 Share Posted June 21, 2012 I have a string that is causing an error using replace: update articles set text = replace(text, ?<p class="p1">QUESTION:</p>?, ?<p class="p1 question">QUESTION:</p>?); What is my syntax issue? Thanks Quote Link to comment Share on other sites More sharing options...
mapleleaf Posted June 21, 2012 Author Share Posted June 21, 2012 Not sure where those question marks came from Anyway this does work: update articles set text = replace(text, '<p class="p1">QUESTION:</p>', '<p class="p1 question">QUESTION:</p>'); So marking as solved Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.