using like and % in MySQLdb

Dave Harrison dave at nullcube.com
Thu Aug 7 06:38:08 CEST 2003


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





More information about the Python-list mailing list