MySQL Forums :: C#, Mono, .Net :: Problem executing the query with escape character

Hi,
I'm a .net developer, working on C#.
I have a MySQL database with table name 'TableA', my requirement is to Get all the records from the TableA whose Comments field is " 'Customer report status set to 'Report Finished'. "

I tried using the following query, but an getting an error related to the escape character.


string cmdStr="SELECT * FROM TableA WHERE TableA.Comments='Customer report status set to \'Report Finished\'.'";

Could anyone please suggest me a solution?

With regards
B1ju