How to pass value to sqlite3 command?

Question

Python

I have a users table, for example, I need to find out how many 1 are in column n6 (column with numbers 1,2,3):

cur.execute("SELECT COUNT(*) FROM users WHERE n6 == 1")
xxx = cur.fetchone()
print(xxx)#получаю вывод: (5,)

Everything works, but I need to look for 1 not only in n6, there are also other columns n7, n8, n9... To do this, I need to substitute the name of the column, but it does not work:

mmml = 'n' + str(6)
cur.execute("SELECT COUNT(*) FROM users WHERE ? == 1", (mmml, ))
xxx = cur.fetchone()
print(xxx)#получаю вывод: (0,)

What could be the problem? When substituting n6, the output is always (0,) no difference to the data from the table

Answer 1

Value substitution in this form does NOT work for identifiers, which are table and field names. In this case, you can substitute through the usual string formatting:

cur.execute("SELECT COUNT(*) FROM users WHERE {} == 1".format(mmml))
или
cur.execute(f"SELECT COUNT(*) FROM users WHERE {mmml} == 1")

Perhaps it would be more correct to change the tables themselves, because these numbered n1...6 look like some kind of crutches.

Answer 2

eye bleeding :)

cur.execute("SELECT COUNT(*) FROM users WHERE ? = 1 OR ? = 1 ", ("n7","n8" ))
xxx = cur.fetchall()