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.

Reply via email to