python数据库输出结果存到列表中_SQL数据库查询返回具有列表中所有值的记录（Python）...

如果我理解正确，“like”子句符合您的要求，但您不知道如何将列表转换为“like”子句。在

所以代码如下：import sqlite3

with sqlite3.connect("animeData.db") as db: #anime database

c = db.cursor()

#self.genreResults is the list containing the genres i want to query

user_input = self.genreResults # for example: ['Action','Drama']

convert_to_like_conditions = ' and '.join(list(map(lambda item : "genre like '%{0}%'".format(item), user_input)))

print(convert_to_like_conditions) #Output: genre like '%Action%' and genre like '%Drama%'

c.execute("select * from t where %s" % convert_to_like_conditions )

results = c.fetchall()

print(results)

db.commit()