How to pass a python variable to a MS SQL SELECT instruction?

Question

Why this code returns nothing?

ip = '10.113.205.55'

cursor.execute("Select * from tablename WHERE ip like '%s' "), ip

result = cursor.fetchall()

print result

when i use the code below it works:

cursor.execute("Select * from tablename where ip like '10.113.205.55' ")

result = cursor.fetchall()

print result

Possible duplicate of How to use variables in SQL statement in Python? — midori
– midori, Commented Jan 28, 2016 at 17:39

Daniel · Accepted Answer · 2016-01-28 17:38:51Z

1

You should remove the ' and put ip inside the parameter list:

cursor.execute("SELECT * FROM tablename WHERE ip LIKE %s", [ip])

answered Jan 28, 2016 at 17:38

Daniel

42.9k4 gold badges57 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ismael Infante · Accepted Answer · 2016-01-28 17:33:35Z

0

change the argument of cursor.execute method to:cursor.execute("Select * from tablename WHERE ip like '%s'" % ip)

answered Jan 28, 2016 at 17:33

Ismael Infante

5324 silver badges8 bronze badges

OMG, how i didnt see that... It Works now, thnx!

But look at @Daniel answer.