MySQL: mysql_real_escape_string in SEARCH query

Question

How can I add mysql_real_escape_string to this search query?

mysql_query("SELECT * FROM logs WHERE text LIKE '%$text%'");

$text comes from a POST-funktion. I have tried a lot of combinations with no success.

TRIED:

mysql_query("SELECT * FROM logs WHERE text LIKE '" . mysql_real_escape_string(%$text%) . "'");
mysql_query("SELECT * FROM logs WHERE text LIKE 'mysql_real_escape_string(%$text%)'");

Answer 1

WHERE text LIKE '%".mysql_real_escape_string($text)."%'")