[Tutor] Searching for email id in MySQL giving wrong results

[John Joseph]

--- Danny Yoo <dyoo at hkn.eecs.berkeley.edu> wrote:

> > 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?
> 

Hi 
    It gives me the  correct result , but I  have
problem in running a program in which it ask for which
 email to be searched , 
I am lost and confused  there , I had marked it in my
code 
***
import MySQLdb
s_email = raw_input("Enter the Email  to be searched
")
db = MySQLdb.connect(host="localhost",user = "john",
passwd = "asdlkj", db = 'learnpython')
entry = db.cursor()
""" I get confused here , in the SQL statement we use
%s for the searched string ,
here I also need to use another % for  pattern
matching , I get lost over here
"""
entry.execute("""SELECT * FROM contact WHERE email_id 
=  %s """, (s_email,))
#entry.execute("""SELECT * FROM contact WHERE email_id
  like  %s%  """, (s_email,))
p = entry.fetchall()
print p














> 
> Best of wishes to you!
> 
> 



		
___________________________________________________________ 
To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com