[sqlalchemy] Select like but the other way around

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

Re: [sqlalchemy] Select like but the other way around

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) 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