Escape single quote in DB connection

Mareetta
New Contributor III
New Contributor III

Is there a way to escape special characters in MySQL connection? I am trying to escape a single quote in UPDATEACCOUNTJSON where a user's name is like O'Reilly

 

1 REPLY 1

rushikeshvartak
All-Star
All-Star

{
"UpdateAccountQry": [
'${"UPDATE table SET  NAME= '${user.name}' WHERE USERNAME='xyz' }'
]
}


Regards,
Rushikesh Vartak
If the response is helpful, please click Accept As Solution and kudos it.