Inserting ' into database

[Peter Lauri]

Hi all,

Assume that I want to insert "Juanita O'Connell" into my database. How do I
do that? The problem is the ' in her last name. If I just put it in it will
be

INSERT INTO thetable (name) VALUES ('O'Connell');

And that does not work :) How can I solve this?

Best regards,
Peter Lauri