Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

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 you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.