Select from MySql with a variable

Question

I'm trying to search in a database with python3 with PyMySQL. I want to have a list of ips, that can be put in a database and return that data to the ip address.

But i can't even search for one ip. Is it possible or not ?

ip = "10.0.4.64"
cur_syslog.execute("SELECT data FROM firewall WHERE source_ip = values (%s)",(ip))

Capitalization. Title. – Cory Charlton Jun 09 '15 at 22:31 — Cory Charlton, Jun 09 '15 at 22:31

score 1 · Accepted Answer · answered Jun 09 '15 at 23:07

1

Your query is not well written. It should be:

cur_syslog.execute("SELECT data FROM firewall WHERE source_ip = %s", (ip))

answered Jun 09 '15 at 23:07

Barranka

20,547
13
65
83

Select from MySql with a variable

1 Answers1