1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Shaughnessy ' and active='Y'' at line 1

Select author_id from author_master where author_name = 'Hugh O'Shaughnessy ' and active='Y'

Error