[ SQLite ]

Question

如何用Python编写SQL查询来选择诸如Python列表之类的元素？

例如，我有Python字符串列表

Names=['name_1','name_2',..., 'name_n']

和SQLite_table。

我的任务是找到最短的方法

SELECT elements FROM SQLite_table WHERE element_name LIKE '%name_1%'
SELECT elements FROM SQLite_table WHERE element_name LIKE '%name_2%'
...
SELECT elements FROM SQLite_table WHERE element_name LIKE '%name_n%'

Answer 1

您将需要表单name_1|name_2|name_3|…的正则表达式，您可以使用'|'.join(Names)生成该表达式。

SELECT elements FROM SQLite_table WHERE element_name REGEXP 'name_1|name_2|name_3|…|name_n'

有关如何在How do I use regex in a SQLite query?中使用正则表达式的说明，请参阅SQLite。

Answer 2

Mmhh

Names=['name_1','name_2','name_n']
for i in Names:
    sql = "SELECT elements FROM SQLite_table WHERE element_name LIKE '%" + i + "%'" 
    print sql

SELECT elements FROM SQLite_table WHERE element_name LIKE '%name_1%'
SELECT elements FROM SQLite_table WHERE element_name LIKE '%name_2%'
SELECT elements FROM SQLite_table WHERE element_name LIKE '%name_n%'