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