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.

In the world of data analysis, advanced SQL techniques are essential for extracting valuable insights from complex datasets. This comprehensive guide by Chandoo delves into these powerful techniques, ...