How to query keyword with an apostrophe?

kindjoen

I need to query content whose title is "Nima's file".

Apparently, these two query have syntax errors:

SELECT object_name FROM dm_document WHERE title='Nima's file'

SELECT object_name FROM dm_document WHERE title="Nima's file"

This query is syntactically correct, but can not fetch the object.

SELECT object_name FROM dm_document WHERE title='Nima$#39;s file'

What is the correct query then? Thanks!

santoshsmud

Try this:

SELECT object_name FROM dm_document WHERE title='Nima''s file'