SQL escape sequence problems

[Asle Pedersen]

I'm trying to run the following code:

father="something"
sql="SELECT FROM TABLE WHERE MESSAGEID='%s'" % (father)
MySQL.escape(sql)

but there is a problem since ' is really an escape character. How can I get
around this problem? I'm using MySQLmodule-1.2. running under win32
enviroment. I have tried to get a compiled version of the MySQLdb module
whithout any success.

regards,
Asle