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

[Alan Gauld]

>  I am trying to search and display the results , even
> if we  give a part of the email_id 


>        entry.execute("""SELECT * FROM contact WHERE
> email_id  =  %s """, (s_email,))


If you want to do partial matches you will need to use LIKE

'''
SELECT * FROM contact 
WHERE email_id LIKE %s
'''

Using = will only check for an exact match, and as you show 
that works OK.

HTH,

Alan G
Author of the learn to program web tutor
http://www.freenetpages.co.uk/hp/alan.gauld