in reply to Re: Checking for Dupes in MySQL
in thread Checking for Dupes in MySQL

SELECT DISTINCT $field FROM $table

Will omit all duplicate values occurring in field

Replies are listed 'Best First'.
Re: Re: Re: Checking for Dupes in MySQL
by ehdonhon (Curate) on Nov 29, 2001 at 18:53 UTC

    SELECT DISTINCT will only prevent you from seeing duplicates. It will not prevent duplicates from being inserted.

[reply]

In Section Seekers of Perl Wisdom