Sqlite Select Query with where clause in python return none

Question

My sqlite select query with where clause in python return none or empty (>>> )

import os.path
import sqlite3

BASE_DIR = os.path.dirname(os.path.abspath(__file__))
db_path = os.path.join(BASE_DIR, "Dictionary.db")
with sqlite3.connect(db_path) as db:
    t = ('hello',)
    cursor = db.cursor()
    cursor.execute("SELECT * FROM entries Where word=?",t)
    Value = cursor.fetchall()
    for i in Value:
        print (i)

Output: ( >>> )

But when I use simple select query without where clause it returns all data

Please paste the INSERTs, so that people can reproduce the behavior. Also, maybe you're just missing quotes around the word i.e.: SELECT * FROM entries Where word="?". — Peter Badida
– Peter Badida, Commented Sep 23, 2017 at 8:41
What is the output of SELECT word='hello', * FROM entries? Does one row get marked with 1? — CL.
– CL., Commented Sep 23, 2017 at 9:56
Yes I have because this is db of dictionary containing 176023 words — Muhammad Awais
– Muhammad Awais, Commented Sep 23, 2017 at 13:00

sixela · Accepted Answer · 2017-12-18 08:49:56Z

2

Try this query:

cursor.execute("SELECT * FROM entries Where word=?",(t,))

The second argument should be a tuple or a list.

answered Dec 18, 2017 at 8:49

sixela

1061 silver badge7 bronze badges

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

Collectives™ on Stack Overflow

Sqlite Select Query with where clause in python return none

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related