MySQLdb compare lower

Anatoli Hristov tolidtm at gmail.com
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