擅长:python、mysql、java
<p>我也有同样的问题:
<a href="https://stackoverflow.com/questions/2640628/sqlalchemy-an-efficient-better-select-by-primary-keys">SQLAlchemy: an efficient/better select by primary keys?</a></p>
<pre><code>terms = ['one', 'two', 'three']
clauses = or_( * [Table.field == x for x in terms] )
query = Session.query(Table).filter(clauses)
</code></pre>
<p>你喜欢这个吗?</p>