[DB-SIG] How to pass parameter with LIKE

Andy Todd andy47 at halfcooked.com
Wed Oct 25 11:44:12 CEST 2006

Janice Sterling wrote:
> 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
> ------------------------------------------------------------------------

That should be fine as long as you use bind parameters. Which database 
and DB-API module are you using?

 From the desk of Andrew J Todd esq - http://www.halfcooked.com/

More information about the DB-SIG mailing list