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

google-app-engine gql gqlquery
srivigneshwar picture srivigneshwar · Apr 17, 2010 · Viewed 8.2k times · Source

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 ??

Answer

CoreyD picture CoreyD · Apr 17, 2010 
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

Related questions

What's the best way to count results in GQL?

I figure one way to do a count is like this: foo = db.GqlQuery("SELECT * FROM bar WHERE baz = 'baz') my_count = foo.count() What I don't like is my count will be limited to 1000 max and my query will …

Read More
Google App Engine: Is it possible to do a Gql LIKE query?

Simple one really. In SQL, if I want to search a text field for a couple of characters, I can do: SELECT blah FROM blah WHERE blah LIKE '%text%' The documentation for App Engine makes no mention of …

Read More
How do I query in GQL using the entity key

How do I write a query against the entity key using GQL in the Google App Engine Data Viewer ? In the viewer, the first column (Id/Name) displays as name=_1, in the detail view it shows the key as Decoded …

Read More