Hi
Thanks for the tip
now I am trying to do pattern matching for MySQL , but
I am not getting the result
on MySQL , to select for all email starting with
jos we do
select * from contact where email_id like "jos%";
but I get confused how to use it , while executing
it in python , how to call the pattern matching inside
mysql query
I had added my code
Thanks
Joseph John
***********************************************************
import MySQLdb
s_email= raw_input("Enter the some part of 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
like %s''', (s_email,))
#s = entry.fetchall()
#print s
entry.execute('''SELECT * FROM contact WHERE email_id
like %s''', (s_email,))
s = entry.fetchall()
print s
~
~
--- "ZIYAD A. M. AL-BATLY" <[EMAIL PROTECTED]> wrote:
> On Sun, 2006-01-22 at 12:43 +0000, John Joseph
> wrote:
> > Hi
> Hi John...
>
> Most of your problems in your code seems to be
> caused by a single
> mistake. Compare the following two strings and you
> should figure out
> what's wrong by yourself:
>
> email_id = '[EMAIL PROTECTED]'
>
> wrong_string = '''SELECT s FROM t WHERE
> id=%s''' , (email_id)
> right_string = '''SELECT s FROM t WHERE
> id=%s''' % (email_id)
>
> print "Wrong:", wrong_string
> print "Right:", right_string
>
> This is the output:
> Wrong: ('SELECT s FROM t WHERE id=%s',
> '[EMAIL PROTECTED]')
> Right: SELECT s FROM t WHERE
> [EMAIL PROTECTED]
>
> Now, which one is the right one? And which one is
> the one you want?
>
>
> I suggest you study strings more, especially
> concatenation and '%'.
>
> If you need more help, just post to the mailing list
> again.
> Ziyad.
>
>
___________________________________________________________
To help you stay safe and secure online, we've developed the all new Yahoo!
Security Centre. http://uk.security.yahoo.com
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
