[thelist] multiple rows in the MySQL with same value

Fred Jones fredthejonester at gmail.com
Thu Jul 31 13:37:56 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.

Technically AFAIK it is the first one it finds, i.e. at random. In
practice, result sets are *generally* returned in the order the
records were inserted into the table. This is my experience anyhow.

More information about the thelist mailing list