using like and % in MySQLdb

[Dave Harrison]

Im sure this is a really obvious problem but :

self.curs.execute(
        """SELECT * FROM user WHERE login LIKE '%%s%'""", [login]
        )

will not work ... gives me an "unsupported format character ''' (0x27)"

escaping the %'s with % as the doco recommends wont work either.

however this :

self.curs.execute(
        """SELECT * FROM user WHERE login LIKE '%dave%'"""
        )

does work

so what's the go ?
cheers
Dave