Error using NOT IN

Other SQL Server Topics
1

I am trying to use the below query to exclude a certain string under my description column.

SELECT * from logs l
WHERE l.description NOT IN ('Illegal string offset 'DatePosted'')

The issue that I am having is that the string returning in our database that I am trying to exclude using the NOT IN clause contains apostrophes and mysql is not liking the apostrophe within the NOT IN at the end of DatePosted and am unsure how to tell mysql that the string contains the apostrophes.

I appreciate any help!

2

To escape single quotes within a string literal, you use another single quote.

x = 'blah blah ''DatePosted'' blah blah'
3

Thanks so much for the help that works.