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?](http://stackoverflow.com/questions/902408/how-to-use-variables-in-sql-statement-in-python) — midori, Jan 28 '16 at 17:39

score 1 · Answer 1 · answered Jan 28 '16 at 17:38

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 '16 at 17:38

Daniel

score 0 · Accepted Answer · answered Jan 28 '16 at 17:33

0

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

answered Jan 28 '16 at 17:33

Ismael Infante

OMG, how i didnt see that... It Works now, thnx! – Victor Giacometti Jan 28 '16 at 17:45
But look at @Daniel answer. – Ismael Infante Jan 28 '16 at 17:50

2 Answers2