Basic MySQL Like functionality using Java Step 1: Fetch the whole table
Step 2: For each row: query= query.toLowerCase(); temp = dbname.getTablename().toLowercase if(temp.contains(query)){ //do stuff... } Hope it helps.. On Thu, Aug 6, 2009 at 3:21 PM, Barry Hunter <barrybhun...@googlemail.com>wrote: > > You cant do full 'like' capabilities, but can do basic 'startswith' > using the trick mentiond here: > > http://code.google.com/appengine/docs/python/datastore/queriesandindexes.html#Introducing_Indexes > > Also have a look around for the various 'full text' search implementations. > > For 'NOT' you do have != which will probably work with 'None' which is > close to a python equivalent of null. This will have to variable > subsituation rather than a string constant to put the 'none' there > though. > > > 2009/8/6 ssprauer <stephane.spra...@gmail.com>: > > > > I am looking forward to code some GQL queries that would retrieve data > > like SQL "IS NOT NULL" and "LIKE" queries. > > > > I would be very grateful to see an example... > > > > Cheers, > > > > Steve > > > > > > > > > > > -- > Barry > > - www.nearby.org.uk - www.geograph.org.uk - > > > > -- Hrishikesh Bakshi --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to google-appengine@googlegroups.com To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---