Is there any function that escapes the special characters

[getmeidea]

Hi All,

select '\';
The above will give me error because mysql uses '\' as escape character.

So i changed the query to,
select '\\';

Here i don't want to worry with escape character stuff. So i need a function
which takes the parameter
1> parameter value = '\'
return value = '\\'
2> parameter value = '\t'
return value = '\t'
2> parameter value = 'St'Johns'
return value = 'St''Johns'

Is there any function like this ?

[mwasif]

You can use mysql_real_esca pe_string() in PHP to escape such characters.