In another thread, this was said: >>So something that actually had me hung up for a long time was how to >> do something like this: >> "select * from Someplace where something like '%word%' "
> >The Django docs show how to do this clearly with the keyword CONTAINS > >and shows the SQL equivalent. >that is a common misconception of ORM I have to agree that SO takes it a >little to far into the Object part but you need to stop thinking of queries >that is not how a ORM is supposed to work, you don't do select * or select >col1,col2,col3, you ask for the object Foo and it will return that object >you will ask for all objects of type foo that have lastname = var. I would like to know what the proper ORM way of searching for all objects with lastnames that contain "smith." I'd like it to return names like Smithson, Blacksmith, and Besmither, as well as just plain Smith. I know how to do this with a %like% search in sql, but, I'd like to do it correctly with SO. Any tips? Thanks, Tamara --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
