Certainly, it's called making a unique index on the field(s) you want to keep unique.
Hope that helps. j----- k----- On Wednesday 07 July 2004 12:48 pm, John Mistler said something like: > Is there a way to do an INSERT on a table only if no row already exists > with the same info for one or more of the columns as the row to be > inserted? That is, without using a method outside SQL? > > Thanks, > > John -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]