擅长:python、mysql、java
<p>只需使用<a href="http://docs.python.org/library/functions.html#getattr">getattr</a>标准python库函数按名称获取属性:</p>
<pre><code>col_name = 'subject'
db_session.query(Notice).filter(getattr(Notice, col_name).like("%" + query + "%"))
</code></pre>