[DB-SIG] Re: [meta-sig] select statement for python-mysql

[Danny Yoo]

> > im facing a problem with the syntax in python-mysql. this is my code:
> >
> >
>
> The syntax for the string substitution needs to have a '%' instead of a ','
>
> c.execute("""select vid from verses where
> book,chapter,number=%s,%s,%s""" %(bk,chap,i))

[redirected to db-sig]

The syntax of that select SQL statement itself looks funny to me; are you
sure you don't mean this instead?

     select vid from verses
     where book = %s
       and chapter = %s
       and number = %s

Good luck!