for example, I'd like to search for keywords "foo", "bar" and possibly but not necessarily more keywords in the "description" column of my *Item* class, so I build a list of such keywords: ["foo", "bar"],
and then use primitive looping to achieve my goal: query_obj = session.query(Item) for k in search_keywords: query_obj = query_obj.filter(Item.description.like('%{0}%'.format(k))) but this doesn't seem very elegant. I think there could be a better solution in sqlalchemy. Could someone share some tips other than looping and chaining? Thanks. p.s. Also what is the best practice to achieve a "OR" search of multiple(indefinite number of) keywords? -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.