From: shop-and-order.net ServiceCenter Date: September 10 2000 11:56am Subject: LIMIT and affected rows List-Archive: http://lists.mysql.com/mysql/50188 Message-Id: <000201c01b1e$277016c0$0400a8c0@internet.int> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi MySQL-Team! I know, this has been asked before, but is it possible (in a future Version maybe???) to get the count-result of affected rows out of a select .. limit statement? This would be very helpful because now we have to do two selects - and this will need time... Thanks for any answers. Helge Schacht _______________________________________ Helge Christian Schacht Internetservice shop-and-order.net InternetMarketing email: hcs@stripped http://shop-and-order.net