MySQLdb compare lower

Anatoli Hristov tolidtm at
Tue Dec 11 23:39:42 CET 2012

> I think this will work:
>     sql = 'UPDATE product SET price=%s WHERE LOWER(sku)=%s'
>     cursor.execute(sql, (price, sku.lower())
Thanks John, this works, I was about to make double check with lower
and upper, but this saves me :)

Thanks a lot.

More information about the Python-list mailing list