This is not a bug. Why don't you just select * from abc where field2 = 'I am
the first';? Or:
mysql> select *, min(field2) from abc group by field1;
+------+--------+-----------------+----------------+
| ID | field1 | field2 | min(field2) |
+------+--------+-----------------+----------------+
| 1 | 1 | I am the first | I am the first |
| 3 | 2 | I am the first | I am the first |
| 6 | 3 | I am the second | I am the first |
+------+--------+-----------------+----------------+
3 rows in set (0.00 sec)
> Hi,
>
> Using this script, you can see the problem.
> I want to receive only the records with string 'I am the first'
> The select will return one record with string 'I am the second'
>
> please, send me any suggestion or bug-fix.
>
> Rodrigo
> mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php