'Error in insert query in doctrine migration

I have the following query which is running perfectly fine.

insert into `mytable` values('it','{
            
    "my_page": "e avete domande, inviate un''e-mail a ",
    "final_file_name": "Ifirmato",
        "zipFile_Name": "Files allegati"
}\')');

un''e-mail in final_page property is giving error. I put 2 single quotes because one single quote is part of the value. In the standalone query, it is working. But inside the method, it is giving an error.

enter image description here

What mistake I am doing?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source