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!