How to escape apostrophe (a single quote) in MySQL?

The [MySQL documentation][1] says that it should be `\'`. However, both SciTE and MySQL shows that `''` works. I saw that and it works. What should I do? [1]: http://dev.mysql.com/doc/refman/5.0/en/string-literals.html#character-escape-sequences