[DB-SIG] How to pass parameter with LIKE

Janice Sterling msmapper at gmail.com
Wed Oct 25 06:14:31 CEST 2006


I am trying to use a sql query where i'm passing a parameter

sql_str = "SELECT mrc_code FROM blocks where mrc_code LIKE '%s'" % (blkfld)

where blocks would be 31103a1, 31103e1, 31103a5, 31103e5
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/db-sig/attachments/20061024/fdf1fef5/attachment.htm 


More information about the DB-SIG mailing list