[thelist] multiple rows in the MySQL with same value

Nan Harbison nan at nanharbison.com
Thu Jul 31 13:34:13 CDT 2008


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.


-----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



* * Please support the community that supports you.  * *

For unsubscribe and other options, including the Tip Harvester and archives
of thelist go to: http://lists.evolt.org Workers of the Web, evolt ! 

More information about the thelist mailing list