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

[Alan Gauld]

> On Sun, 2006-01-22 at 21:23 +0300, ZIYAD A. M. AL-BATLY wrote:
>>         wrong_string = '''SELECT s FROM t WHERE id=%s''' , (email_id)
> 
> The string is being used in a call to cursor.execute.  The email_id is a
> second parameter getting passed to execute.  That is the *correct*
> approach to use.

Nope, sorry. 
This sends the string

SELECT ..... id=%s something at somewhere.whatever

ie the %s is kept in the string, not what is wanted.

The OP must replace the comma with a % character for the string 
substitution to take place.

> That is no help in explaining why the SELECT command is failing to
> return the expected results.

The rogue %s in the select string will mess things up.

Alan G.