Problema con query ohp-mysql

[Patriarka]

Error de consulta: :

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 'WIMBLEDON' - MATTHEW PERRY - LOS ANGELES, CA - SEPT. 13, 2004' ' at line 2

QUERY: SELECT * FROM file_informacion_value WHERE fileinfoval_value = 'FEAT 6006 - C01 - IMAGE9960066B - FILM PREMIERE OF 'WIMBLEDON' - MATTHEW PERRY - LOS ANGELES, CA - SEPT. 13, 2004' AND fileinfo_id = '167'

Hola amigos, evidentemente tengo un problema con las comillas,
use mysql_real_escape_string y no me soluciona el probleme.

el codigo php es este:

$value = "FEAT 6006 - C01 - IMAGE9960066B - FILM PREMIERE OF 'WIMBLEDON' - MATTHEW PERRY - LOS ANGELES, CA - SEPT. 13, 2004";
$value = mysql_real_escape_string($value);

$sql = "SELECT * FROM file_informacion_value WHERE fileinfoval_value = '$value' AND fileinfo_id = '167' ";