SELECT fullname FROM `table` WHERE fullname LIKE '%Artist\\\\\''s Proof%'

in my php document where I make the mysqli call, five backslashes and two apostrophe get it done

at my cpanel console five backslashes and one apostrophe does the trick