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

[Kent Johnson]

John Joseph wrote:
> Hi  
>    Thanks to Allan,Danny,Pujo 
>        I did my simple python script  for  MySQL , the
> scripts add the data , and search for the data and
> display 
>           I have problem in searching  email id  ,ie 
> If search for the  something at some , I will not get any
> result , Guidance and advice needed  for the reason
> for this behavior

Does it work when you search for other data such as name or phone?

Can you show the output from a short run where you add a contact, 
display the data and search for an email?

Kent

>  I had added my script in this mail 
>                       Thanks 
>                              Joseph John 
> 
> *********************************************************
> 
> """ This program is for to learn 
> 	how to enter data to MySQL using python
> 	How to search 
> 	not using OOP 
> 	
>       Have  problem in searching email-id 
>         Why I do not get correct results when 
>          searching email id 
>        "@" string search  containg "@" gives empty
> results
> 
> """
>          
> 
> 
> import MySQLdb
> 
> def selecter():
> 	choice = None
> 	while choice != "0":
> 		print \
> 		"""
> 		Data Base Entry for the  Testing Env
> 		0	-	Quit
> 		1	-	Enter the Data
> 		2	-	Display The data
> 		3	- 	Search The Company 
> 		"""
> 		choice = raw_input("Choice :........")
> 		print 
> 	
> 	 	if choice == "0":
> 			print "Good Bye ..."
> 		elif choice == "1":
> 			dataentry()
> 
> 		elif choice == "2":
> 			datashow()
> 		elif choice == "3":
> 			datasearch()
> 
> 
> 
> def dataentry():
> 	name = raw_input("Enter the name of the company ")
> 	email_id = raw_input("\n Enter the email ID : ")
> 	phone_no = raw_input("Enter the Phone No : ")
> 	fax_no	= raw_input("\n Enter the fax no : ")
> 
> 	db = MySQLdb.connect(host="localhost",user = "john",
> passwd = "asdlkj", db = 'learnpython')
> 	entry = db.cursor()
> 	#entry.execute("""INSERT INTO contact
> """,(name,email_id,phone_no,fax_no,))
> 	entry.execute("""INSERT INTO
> contact(name,email_id,phone_no,fax_no) VALUES
> (%s,%s,%s,%s)""",(name,email_id,phone_no,fax_no,))
> 	print  name , email_id , fax_no, phone_no
> 
> 
> 
> 
> def datashow():
> 	db = MySQLdb.connect(host="localhost",user = "john",
> passwd = "asdlkj", db = 'learnpython')
> 	entry = db.cursor()
> 	entry.execute("SELECT * from contact")
> 	p = entry.fetchall()
> 	print p
> 
> def datasearch():
> 	print "Do U want to search by Name , email id , phone
> or fax "
> 	choice = None
> 	while choice != "0":
> 		print \
> 		"""
> 		 U want to search the contacts by  
> 		0	-	Quit
> 		1	-	Name 
> 		2	-	email_id
> 		3	- 	phone
> 		4	-	fax 
> 		"""
> 		choice = raw_input("Choice :........")
> 		print 
> 	
> 	 	if choice == "0":
> 			print "Good Bye ..."
> 		elif choice == "1":
> 			searchbyname()
> 
> 		elif choice == "2":
> 			searchbyemail()
> 		
> 		elif choice == "3":
> 			searchbyphone()
> 		elif choice == "4":
> 			searchbyfax()
> 	
> def searchbyname():
> 	s_name = raw_input("Enter the name to be searched ")
> 	db = MySQLdb.connect(host="localhost",user = "john",
> passwd = "asdlkj", db = 'learnpython')
> 	entry = db.cursor()
> 	entry.execute("""SELECT * FROM contact WHERE name =
> %s""", (s_name,))
> 	p = entry.fetchall()
> 	print p
> 
> def searchbyemail():
> 	s_email = raw_input("Enter the Email  to be searched
> ")
> 	db = MySQLdb.connect(host="localhost",user = "john",
> passwd = "asdlkj", db = 'learnpython')
> 	entry = db.cursor()
> 	entry.execute("""SELECT * FROM contact WHERE email_id
> = %s""", (s_email,))
> 	p = entry.fetchall()
> 	print p
> 
> 
> def searchbyphone():
> 	s_phone= raw_input("Enter the Phone no   to be
> searched ")
> 	db = MySQLdb.connect(host="localhost",user = "john",
> passwd = "asdlkj", db = 'learnpython')
> 	entry = db.cursor()
> 	entry.execute("""SELECT * FROM contact WHERE phone_no
>  = %s""", (s_phone,))
> 	p = entry.fetchall()
> 	print p
> 
> 
> 
> def searchbyfax():
> 	s_fax = raw_input("Enter the FAX no  to be searched
> ")
> 	db = MySQLdb.connect(host="localhost",user = "john",
> passwd = "asdlkj", db = 'learnpython')
> 	entry = db.cursor()
> 	entry.execute("""SELECT * FROM contact WHERE fax_no =
> %s""", (s_fax,))
> 	p = entry.fetchall()
> 	print p
> 
> selecter()
> 	
> 
> 
> 
> 		
> ___________________________________________________________ 
> Yahoo! Photos – NEW, now offering a quality print service from just 8p a photo http://uk.photos.yahoo.com
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> http://mail.python.org/mailman/listinfo/tutor
> 
>