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 it.
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
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)|
