SQL Query problem using mysql_real_escape_string() function

See more:

SQL

PHP

MySQL

Hi Friends

I am working on a PHP, MySql web application. But I am confronting a critical error using mysql_real_escape_string function
For Example:
My SQL Query is

$query = "Select * from tbl_name where field_name = 'Pirates'";

after passing it from mysql_real_escape_string() function this query becomes

$query = "Select * from tbl_name where field_name = \'Pirates\'";

So now although 'Pirates' exists in my database but now it has become \'Pirates\'. Therefore when I run this query it gives me no record.
Note: If i search any field whose data type is numeric, this query gives me the correct result. (Because no quote is used for a numeric data)

Can some one has the solution for this problem?