using like and % in MySQLdb
dave at nullcube.com
Thu Aug 7 06:43:06 CEST 2003
Im sure this is a really obvious problem but :
"""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 :
"""SELECT * FROM user WHERE login LIKE '%dave%'"""
so what's the go ?
More information about the Python-list