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 <[email protected]>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 <[email protected]>:
> >
> > 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 [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
-~----------~----~----~----~------~----~------~--~---
