try db.books.select(db.books.c.book_skus.like('abcd%'))
On 3/5/07, dan <[EMAIL PROTECTED]> wrote: > > I'm trying to track down the syntax for using a 'like' clause with sql > soup. I'm trying to do something like > select book_sku from books where book_sku like 'abcd%'; > > best i can tell, my syntax should look something like: > skus = db.books.select(book_skus.like('abcd%')) > > but I'm getting an error, so obviously not. Pointers? > > tia, > dan > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---