No se pudo ejecutar la consulta

SELECT p.id,p.title,p.title_alias,p.hits,c.title as cate FROM mos_content p, mos_categories c WHERE c.id = p.catid AND (p.actor LIKE '%Brian O'Halloran%' OR p.director LIKE '%Brian O'Halloran%')

Error MySQL: : 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 'Halloran%' OR p.director LIKE '%Brian O'Halloran%')' at line 1

Este Script no puede continuar.