Thanks for the prompt replies. Is there any way direct or indirect to match part of a string using java...
Regards On Mon, Oct 18, 2010 at 6:47 PM, Sahid Orentino Ferdjaoui < [email protected]> wrote: > Hello, > > see at this url: > > http://code.google.com/appengine/docs/python/datastore/queriesandindexes.html > > > > Tip: Query filters do not have an explicit way to match just part of a > string value, but you can fake a prefix match using inequality filters: > > > > db.GqlQuery("SELECT * FROM MyModel WHERE prop >= :1 AND prop < :2", > "abc", u"abc" + u"\ufffd") > > > > This matches every MyModel entity with a string property prop that begins > with the characters abc. The unicode string u"\ufffd" represents the largest > possible Unicode character. When the > property values are sorted in an > index, the values that fall in this range are all of the values that begin > with the given prefix. > > -- > . > ..: > > > > On Mon, Oct 18, 2010 at 3:10 PM, Vibhuti Gupta <[email protected]> > wrote: > > Hello > > Anyone has any idea about some alternative to 'like' clause. I need to > write > > a query where I need to select users having a particular string in their > > username. > > Thanks > > > > -- > > You received this message because you are subscribed to the Google Groups > > "Google App Engine" group. > > To post to this group, send email to [email protected]. > > To unsubscribe from this group, send email to > > [email protected]<google-appengine%[email protected]> > . > > For more options, visit this group at > > http://groups.google.com/group/google-appengine?hl=en. > > > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-appengine%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google App Engine" 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/google-appengine?hl=en.
