Update 'table' set the body=replace (body, '& lt; Font color="# 136 ec2" & gt; ', ' ')

'& lt; Font color="# 136 ec2" & gt; 'main is this sentence prompts You have an error in your SQL syntax, grammar mistakes, I tried a lot of kinds of escape or not, I hope aunt help, thank You!

CodePudding user response:

The same post the complete error message,
Now look at your 'table name using single quotes, this is wrong,

CodePudding user response:

Single quotes this know, ` ` it is ok to use this, played, I am Posting is & lt; Font color="# 136 ec2" & gt; This sentence has grammatical errors in SQL statement, how to write don't complain

CodePudding user response:

Post your full statement and full error for analysis,

CodePudding user response:

The SQL, I test is no problem

CodePudding user response:

The measured, found no problem