Rudy, This is good to know, I have never known the answer to this. If you code the returned query as if there was only one row, do you know which one it would be? Would it be the last one it found, or the first one, or a random one? I would guess it would return the first one it finds. Thanks! Nan -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of r937 Sent: Thursday, July 31, 2008 9:08 AM To: thelist at lists.evolt.org Subject: [thelist] multiple rows in the MySQL with same value > So the more general question I have is - when you do a query for a > value that is in a table more than once, does the query stop on the > first one it finds no, it returns all rows that satisfy the WHERE conditions rudy http://r937.com/ -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !