> the email id which starts with “j”  is
> select * from contact where email_id like 'j%';

Hi John,

Ok, looks good so far.  So in a Python program, we might try something
like this:

##############################################################
                        ## assuming cursor is set up properly:
cursor.execute("select * from coutact where email_id like %s",
               ("j%",))
print cursor.fetchone()
##############################################################

Try an example off the interactive interpreter prompt.  Do you get the
results you expect?


Best of wishes to you!

_______________________________________________
Tutor maillist  -  Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor

Reply via email to