What you want to do is insert the data in the database with the ' replaced with '' . This escapes the apostrophe and won't mess up the query.
Results that may be inaccessible to you are currently showing.
Hide inaccessible resultsResults that may be inaccessible to you are currently showing.
Hide inaccessible results