Search code examples
google-app-enginegqlgqlquery

GQL query help - How can I write a query with where clause in GQL ? I am using google appengine datastore

I have three records in a table example: 

*Usernames*        *email*                *city*
Nick            [email protected]        London
Vikky           [email protected]       Paris
Lisa            [email protected]        Sydney

Now I want to get specific record keeping email ID as a key ,

SQL query may be like this 

select * from table1 where email = "[email protected]"

What is the equivalent GQL query for the above ??

Solution 
  • SELECT * FROM table1 WHERE email = '[email protected]'

    should work fine in GQL.

    See here for more information http://code.google.com/appengine/docs/python/gettingstarted/usingdatastore.html