> 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