[appengine-java] Re: LIKE query workaround for the Low Level API

2009-10-23 Thread harjit.singh
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, B

[appengine-java] Re: LIKE query workaround for the Low Level API

2009-10-22 Thread Max Zhu
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 s

[appengine-java] Re: LIKE query workaround for the Low Level API

2009-10-22 Thread Roy Smith
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) w

[appengine-java] Re: LIKE query workaround for the Low Level API

2009-10-22 Thread Nicholas Albion
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 t

[appengine-java] Re: LIKE query workaround for the Low Level API

2009-10-21 Thread Roy Smith
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 wa

[appengine-java] Re: LIKE query workaround for the Low Level API

2009-10-21 Thread david.zverina
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