Michael Bayer <mike_mp <at> zzzcomputing.com> writes: > > sure it does, if you convert it to a SQL token first: > > literal("C:\test\testfile.txt").like(Table.path + "%") > > or even > > literal("C:\test\testfile.txt").startswith(Table.path)
Thanks for the quick reply! One more quick question, how would I combine two of these like statements, if I just use 'and' between them I get 'TypeError: Boolean value of this clause is not defined'. > On Nov 7, 2011, at 8:40 AM, Paul wrote: > > > I'm trying to do a like statement in a query filter. I'm fine doing it one way > > for instance > > > > session.query(Table).filter(Table.path.like("C:\Test\%")) > > > > which would hopefully return all folders and files in the folder Test > > > > but what if I want to do it the other way around and pass "C:\Test\testfile.txt" > > and return all the folders. I want something like > > "C:\Test\testfile.txt".like(Table.path+"%") but obviously a string wont > > have the > > method like. > > > > is there a function I can import that takes 2 arguements or another method > > I can > > use to achieve this? > > > > Thanks! > > > > Paul > > > > > > > > -- > > You received this message because you are subscribed to the Google Groups "sqlalchemy" group. > > To post to this group, send email to sqlalchemy <at> googlegroups.com. > > To unsubscribe from this group, send email to sqlalchemy+unsubscribe <at> googlegroups.com. > > For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. > > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.