On 15 Nov 2001, at 22:32, Carsten H. Pedersen wrote:
> > Thanks for the response, but I think you missed the key
> > collection_field_value right under the primary key above.
>
> You're right -- Sorry. Have you tried COUNT'ing something
> other than *? i.e. document_id or resource_id?
I tried
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)|
+--++-+---
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]
---
create database
