Using DISTINCT to get unique results

[bnashenas1984]

I'm using DISTINCT to get one of each title out of my table.

Here is my table:

+---------------------------+
|    title     |  weather   |
+---------------------------+
|   Monday     |    Good    |
|   Tuesday    |    Bad     |
|   Wednsday   |    worst   |
|   Tuesday    |    Good    |
+---------------------------+
 

Query =

SELECT DISTINCT title , weather FROM mytable

And my question is:
in this case there is 2 rows with same title (Tuesday). so just one of them will be showed but we also have 2 rows with same weather ( Good ) which dont have same title... I need to know if only one of these three rows will be showed or 2?
What I mean is that I need only unique titles not unique weather...

[pbmods]

Heya, bnashenas.

Please use CODE tags when posting source code:

[CODE=MySQL]
MySQL code goes here.
[/CODE]

Use a GROUP BY clause:

SELECT
    DISTINCT
        `title`,
        `weather`
    FROM
        `mytable`
    GROUP BY
        `title`,
        `weather`
 

[bnashenas1984]

What exactly does it do? I mean GROUP BY

[r035198x]

What exactly does it do? I mean GROUP BY

Read all about it here.

[bnashenas1984]

Thanks guys

It worked

[pbmods]

Heya, Bnashenas.

Glad to hear you got it working! Good luck with your project, and if you ever need anything, post back anytime :)

[bnashenas1984]

Sorry guys
I did all you said but I think I'm still having problem..

What i need is that I want DISTINCT to take effect only on 1 Column ( title ) and I also need to get all rows...

Check this:

SELECT DISTINCT title FROM mytable 
 

But the problem is that this command only returns title column... I mean if i use

$result=mysql_fetch_array();
 

in php i only get result[title] but i need result[weather] too
As you said I also used GROUP BY and i thought it was working but it wasn't

Thanks agin for your replies

[pbmods]

Heya, Bnashenas.

What's your query look like?

[bnashenas1984]

Hello pbmods...
Thanks for your replies.. Actually i solved the problem by using this command :

SELECT * FROM mytable GROUP BY title,weather
 

Thanks again