CodingForums.com - Return unique values only?

CodingForums.com (http://www.codingforums.com/index.php)

- MySQL (http://www.codingforums.com/forumdisplay.php?f=7)

- - Return unique values only? (http://www.codingforums.com/showthread.php?t=274927)

john6

10-02-2012 01:48 PM

Return unique values only?

Is it possible to return values from a field, but only once (no repetitions)?

guelphdad

10-02-2012 02:03 PM

Yes, with DISTINCT.
note that DISTINCT works on all columns selected in a query though in case you are returning more than one column.

All times are GMT +1. The time now is 10:23 AM.