> if i perform a SELECT query (say) like the following:
>
> SELECT email_addr FROM myTable WHERE x = 1
>
> in this query i want to pull-out (or list) all email
> addresses where x equals 1, however, suppose i don't want any
> duplicate email addresses... would i use ORDER BY and COUNT(*) to
get listing
> of non-duplicate email addresses, and just ignore the COUNT() ?
You would use neither :) To get the distict email addressese you can
use
SELECT email_addr FROM myTable WHERE x = 1 GROUP BY email_addr
Check MySQL manual for SELECT options for more info.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
