SQLite Forum

Empty condition string in python
Login

Empty condition string in python

(1) By anonymous on 2020-04-22 23:11:40 [link] [source]

If i fill the parameter for a condition in python it will search and fetch me the results but if i leave it empty it will search for empty. I want it to print everything from that column as if there was no condition, but as you know im stuck with the = sign or “is” while writing my condition

(2) By Warren Young (wyoung) on 2020-04-23 02:37:46 in reply to 1 [source]

You're probably calling the wrong function in your Python database API, one which always includes a SQL WHICH clause, but you want to have no WHICH clause at all.

You really need to post some of your code to get more specific advice.