Hope someone can help me with this!
I have a fairly large database containing the following fields..
email , firstname , surname, address1, address2,
However it contains many duplicate entires and would like to be able to select distinct entries based on email address.
select distinct email from tbl_users
Gives me the distinct email address,
select distinct email ,firstname, Surname, from tbl_users
gives me a number of duplicates if someone has entered thier name diffently i.e diplays:
email@example.com fistname surname
firstname.lastname@example.org 1stname surname
Hope there is an easy solution that I've missed!