[appengine-java] Re: LIKE query workaround for the Low Level API
GQL supports > & < for strings. Hence myString LIKE "foo%" becomes myString > 'fonz' AND myString < 'foozz' This was close enough for my purposes but if I expected % to match non- letter characters or non-ascii ones, I'd do some more testing. On Oct 21, 6:34 pm, George Moschovitis wrote: > Hi, > > what is the suggested way to emulate an SQL LIKE 'prefix%' query using > the low level Datastore API? > > thanks, > George. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-java@googlegroups.com To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en -~--~~~~--~~--~--~---
[appengine-java] Re: LIKE query workaround for the Low Level API
Answered in this thread http://groups.google.com/group/google-appengine-java/browse_thread/thread/958851cc674d0c70/7403586fae9ffe20?lnk=gst&q=startswith#7403586fae9ffe20 On Wed, Oct 21, 2009 at 6:34 PM, George Moschovitis < george.moschovi...@gmail.com> wrote: > > Hi, > > what is the suggested way to emulate an SQL LIKE 'prefix%' query using > the low level Datastore API? > > thanks, > George. > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-java@googlegroups.com To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en -~--~~~~--~~--~--~---
[appengine-java] Re: LIKE query workaround for the Low Level API
I don't suppose it's possible to do: myString LIKE "%,foo,%" I'm surprised that the datastore used by a search engine doesn't have better support for string searching/comparison... --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-java@googlegroups.com To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en -~--~~~~--~~--~--~---
[appengine-java] Re: LIKE query workaround for the Low Level API
I think the answer is no, and the irony isn't lost. I haven't looked into it, but depending on the length of your strings, you might be able to store multiple substrings and build a query which applies "like %" across all the substrings. There was an article somewhere (or was it a Google IO talk) which talks about the features of set searches On Thu, Oct 22, 2009 at 11:24 PM, Nicholas Albion wrote: > > I don't suppose it's possible to do: > >myString LIKE "%,foo,%" > > I'm surprised that the datastore used by a search engine doesn't have > better support for string searching/comparison... > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-java@googlegroups.com To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en -~--~~~~--~~--~--~---
[appengine-java] Re: LIKE query workaround for the Low Level API
So far as I know, Bigtable only supports: myString LIKE "foo,%" On Fri, Oct 23, 2009 at 6:24 AM, Nicholas Albion wrote: > > I don't suppose it's possible to do: > >myString LIKE "%,foo,%" > > I'm surprised that the datastore used by a search engine doesn't have > better support for string searching/comparison... > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-java@googlegroups.com To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en -~--~~~~--~~--~--~---
[appengine-java] Re: LIKE query workaround for the Low Level API
Support for StartsWith was added. I think most of us are moving from the SQL world to Bigtable world and things are little bit done differently and we expect it work the same as SQL . You can use > and < which is same as like. - Harjit On Oct 22, 10:10 pm, Max Zhu wrote: > So far as I know, Bigtable only supports: > > myString LIKE "foo,%" > > > > On Fri, Oct 23, 2009 at 6:24 AM, Nicholas Albion wrote: > > > I don't suppose it's possible to do: > > > myString LIKE "%,foo,%" > > > I'm surprised that the datastore used by a search engine doesn't have > > better support for string searching/comparison... --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to google-appengine-java@googlegroups.com To unsubscribe from this group, send email to google-appengine-java+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en -~--~~~~--~~--~--~---