how to escape single quotes in SQL
The simplest method to escape single quotes in SQL is to use two single quotes. For example, if you wanted to show the value O’Reilly, you would use two quotes in the middle instead of one.
the next method is to add a backslash (\) before the single quote.