Query breaking due to single quote

Question

I have query like this

Select * from table where word like 'Adam\'s apple';

But query is breaking even after escaping single quote. Any help?

Error is unexpected "'s" found