Each column has a 'like' method, so you should be able to filter by it: filter(~Table.field.like("%value1%")) Hi to all, I need to realize a query like this
select * from my_table where field not like "%value1%" and field not like "%value2%" with a sqlalchemy sintax. I looked for around the documentation but it seems be impossible. Am I wrong? It's possible that the only way could be to use the engine.execute method? Thanks for any suggestion Best regards Luca -- 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/groups/opt_out. -- 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/groups/opt_out.