unique values from select statement

[Anon]

Hello everyone!!

I am trying to select values from a database table, but I only want it to select each value once.

Eg) I have two records
record a, car, ford
record b, truck, ford

In this example I only want to select "ford" once. Is this possible. How is this done??

Any help would be greatly appreciated!
Thank you!

[junebug]

are you using mysql?

select distinct col from table

[natalie]

the "select distinct" should work with just about any SQL - I've never heard of one that doesn't support the distinct keywork.

[Anon]

so something like

$sql="SELECT DISTINCT on (workshop.dayGroupID) workshop.dayGroupID, groupByDay.dayOfWeek, groupByDay.AorP
FROM workshop
LEFT JOIN groupByDay ON workshop.dayGroupID = groupByDay.dayGroupID
WHERE orgID='$orgID'";

This is what I have now, but it doesn't work. It is actually dayGroupID I needed to be distinct not the "ford" thing, it was just an example.

Any ideas why this doesn't work??
Thanks everyone!