GQL query help - How can I write a query with wher

Question

I have three records in a table example:

*Usernames*        *email*                *city*
Nick            [e-mail]        London
Vikky           [e-mail]       Paris
Lisa            [e-mail]        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 = "[e-mail]" 

What is the equivalent GQL query for the above ??

Answer 1

SELECT * FROM table1 WHERE email = '[e-mail]' 

should work fine in GQL.

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