Liam Delahunty: Home Tips Web Contact
Recommended laptop
under £500.

Think I deserve a present? See my Amazon Wish List

MySQL DISTINCT or GROUP BY


 
SELECT DISTINCT(email), newsletter FROM contact_tbl WHERE newsletter != 0;
1721 rows in set (0.42 sec)

 
SELECT email, newsletter FROM contact_tbl WHERE newsletter != 0 GROUP BY email;
1702 rows in set (0.42 sec)

DISTINCT will in the example above produce more results if a user had been added with more than one type of newsletter. The GROUP BY clause will just get the single email.

Share this!  


Mysql Day Of Year | Mysql Distinct Or Group By | Mysql Errno 145


 

  Tips | Home | Search | Contact

Link here: