Search with an apostrophe in mySQL

[eluser]mexor[/eluser]
When searching for something like "Ocean's 11" I get a database error:

Error Number: 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 's 11%' ORDER BY title ASC' at line 1

SELECT * FROM addDVD WHERE title LIKE '%ocean's 11%' ORDER BY title ASC

How do I get around this?
Thanks!

[eluser]nirbhab[/eluser]
SELECT * FROM addDVD WHERE title LIKE '%ocean\’s 11%' ORDER BY title ASC

Code:

$search_it = "ocean’s";
$key = addslashes($search_it);
$sql = "SELECT * FROM addDVD WHERE title LIKE '%$key%' ORDER BY title ASC";

[eluser]mexor[/eluser]
works perfect, thanks! :-)