How can i use double quotes inside sql update query?

Question

I am trying to fire following command

update employees set text_data="[Demo-Data value="mddhak"]";

I am getting following error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server

userPPJl1 · Answer

You can use SINGLE QUOTES instead to achieve the same

update employees set text_data='[Demo-Data value="mddhak"]';