Posted by Richard Levasseur on 07/07/06 19:54

I think he wants to get a distinct set of all the addresses.

Use the group by clause or the distinct modifier.

Alvaro G. Vicario wrote:
> *** Manish escribió/wrote (7 Jul 2006 04:11:54 -0700):
> >>> Please suggest on this
>
> If you don't make a question I don't really what you kind of suggestions
> you are expecting. Anyway, the best way to avoid duplicate information is
> having a good design so the database is normalised and using primary keys
> and unique indexes so the dupes cannot be physically inserted.
>
>
> --
> -+ http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
> ++ Mi sitio sobre programación web: http://bits.demogracia.com
> +- Mi web de humor con rayos UVA: http://www.demogracia.com
> --

• Next in forum: Re: commenting ?>
• Prev in forum: Re: Where to store pictures, in DB or in files?
• Thread view: Re: Deleting duplicate entries from MySQL database table

[Reply to this message]