If you want to escape a single quote in a MySQL string, you have two ways of doing it:
1. make it two single quotes:
string query = "update database.table set column = column.Replace('''',' ');" ;
2. use the escape character (
\
):
string query = @"update database.table set column = column.Replace('\'',' ');" ;
In the second solution you have to prefix your c# string with the
@
character, so that the compiler does not interpret the escape character in sthe string as a C# escape character (and thus leaves this as it is).
Kindly.