From: Jann Linder
Date: March 12 1999 3:44am
Subject: Delete the first found record in SQL?
List-Archive: http://lists.mysql.com/mysql/66
Message-Id: <199903120344.TAA01899@jann.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

I have a table with 3 fields.

I have many records with IDENTICAL Fields.

I want to pass the following:

delete from tablename where a='a' and b='b' and c='c'

and have the MySQL remove the FIRST RECORD ONLY where this criteria is met.

How is this possible?

HLP ASAP!
Jann

--
Jann Linder
Web Developer
Perl Programmer

Personal Site: http://www.jann.com/
CalendarPlus Site: http://www.calendarplus.com/