Re: MySQLdb compare lower

References	<mailman.742.1355259688.29569.python-list@python.org> <ka8ba8$bpo$1@reader1.panix.com>
Date	2012-12-11 23:39 +0100
Subject	Re: MySQLdb compare lower
From	Anatoli Hristov <tolidtm@gmail.com>
Newsgroups	comp.lang.python
Message-ID	<mailman.751.1355265586.29569.python-list@python.org> (permalink)

Show all headers | View raw

> 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.

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

MySQLdb compare lower Anatoli Hristov <tolidtm@gmail.com> - 2012-12-11 22:01 +0100
  Re: MySQLdb compare lower John Gordon <gordon@panix.com> - 2012-12-11 22:15 +0000
    Re: MySQLdb compare lower Anatoli Hristov <tolidtm@gmail.com> - 2012-12-11 23:39 +0100

csiph-web