How to fetch all distinct rows, SQLite - Android
Here's my table:

    private static final String DATABASE_CREATE =
            "create table entry (_id integer primary key autoincrement, "
            + "date text not null, " +
            "velocity integer not null, " +
            "type text not null, " +
            "xCoord real not null, " +
            "yCoord real not null, " +
            "color integer not null);";

My listView is populated by dates, when the entries were created. So my listView looks something like this:

    December 25, 2011
    December 25, 2011
    December 25, 2011
    December 26, 2011
    December 26, 2011
    December 27, 2011

So basically, every time an entry is saved in the database, it will display the date when it was created. I managed to select unique date, so the same date will only show once, by doing this:

    SELECT * FROM entry GROUP BY date

Now my listView looks like this:

    December 25, 2011
    December 26, 2011
    December 27, 2011

My question is, when I click on a row in the listView, how can I fetch all rows which have the same date as the one I clicked on. For example, If I click on "December 25, 2011" then I want the query to return all information of those 3 rows which have that same date I clicked on.

Thanks in advance.
How to fetch all distinct rows, SQLite - Android
===

Here's my table:

    private static final String DATABASE_CREATE =
            "create table entry (_id integer primary key autoincrement, "
            + "date text not null, " +
            "velocity integer not null, " +
            "type text not null, " +
            "xCoord real not null, " +
            "yCoord real not null, " +
            "color integer not null);";

My listView is populated by dates, when the entries were created. So my listView looks something like this:

    December 25, 2011
    December 25, 2011
    December 25, 2011
    December 26, 2011
    December 26, 2011
    December 27, 2011

So basically, every time an entry is saved in the database, it will display the date when it was created. I managed to select unique date, so the same date will only show once, by doing this:

    SELECT * FROM entry GROUP BY date

Now my listView looks like this:

    December 25, 2011
    December 26, 2011
    December 27, 2011

My question is, when I click on a row in the listView, how can I fetch all rows which have the same date as the one I clicked on. For example, If I click on "December 25, 2011" then I want the query to return all information of those 3 rows which have that same date I clicked on.

Thanks in advance.