Python + SQLite check | HELP

Question

I'd like to check if name I set in Python is in SQLite table > Column. How to make it?
Example:
name = 'John'
Table name: Table_name
column name: Name
Which function should I use?
Please help!

Answer 1

i guess first thing is to insert a name o_O
check = c.execute('INSERT into Table_name VALUES (?)', 'John')

Answer 2

and then:
name="John"
check = c.execute("SELECT name from Table_name WHERE name="+name)

Answer 3

might be for the best
SQL ain't my strong suite xD

Answer 4

have you checked the API?
https://docs.python.org/3/library/sqlite3.html

Answer 5

can you post any code you have so far?

Answer 6

and do you have anything in the table?
sorry my SQL is rusty xD
http://sebastianraschka.com/Articles/2014_sqlite_in_python_tutorial.html
some nice info here

Answer 7

according to the link i posted:
"if we use the .fetchall() method, we return a list of tuples from the database query, where each tuple represents one row entry. "
so it shouldn't be an issue that it displays [(0,)] instead of 0

Answer 8

So, how to pair it with Python? How to check if name is in table?

Answer 9

Yes, checked. But can't find the right function

Answer 10

c = conn.cursor()
name = 'John'
check = c.execute('SELECT count(name) FROM table_name')
c.fetchall()
>>> ([0,])
I need at least 0 instead of ([0,])

Answer 11

No, didn't help. Still the output is [(0,)] instead of 0

Answer 12

I'll check this site