I want to know if it is possible to build a MySQL query which will only
return the unique values of a specific column. Ie if I had this table:
id | name |date_______
1 | Jon | 2001-01-03
2 | Bob | 2001-01-04
3 | Jon | 2001-01-05
Is there any SQL query that will only return 1 row for each value in the
name column, or would I have to do that in PHP?
<Jon>
===============================
And shepards we shall be
For thee, my lord, for thee
For thou hath descended forth from thy hands
That our feats may swiftly carry out thy command
We will flow a river forth unto thee
And teaming with souls shall it ever be...
===============================
http://jcampbell.blacklightning.net
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
