mardi 24 novembre 2015

SQL query or rawquery with return value

I am having trouble writing a query with the example database below:

_id  Status  Name
1       0    Mike
2       1    John
3       1    Paul
4       0    Bob
5       0    Bruce

I would like to iterate through all 5 rows and return John and Paul, because they have a status of 1. Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire