Google sheets query function. Use where clause with string that includes apostrophe

How do you use a string with an apostrophe in the where clause of the query function?

I want to be able to filter my query with a string that includes an apostrophe like this.

=QUERY(D:E;"select E where D = 'this string's apostrophe breaks my code'";0)

Anyone know how to make it work?

>Solution :

This can be done by placing two sets of double quotes around the string you wish to use in your where clause.

For example:

=QUERY(D:E;"select E where D = ""this string's apostrophe breaks my code""";0)