Special characters in mysql

[lional]

Hi All

I have a small problem,

I need to insert certain characters like the comma, and single quotation mark using the INSERT command.

Is there anyway that this can be done

 

Thanks

 

Lional

[PFMaBiSmAd]

Actually, a coma in a string is not a problem. You need to escape the special characters so that they are treated as literal characters instead of their special meaning -

http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html