Hi @steevej al I was after was the MongoDB equivalent of a no-duplicates, the issue came from a personal misunderstanding of how the index works, and I don’t know how to explain what I’ve ended up using exactly.
I’m not interested in searching for .uk or .co.uk in this field as there is also a tld field for that purpose.
I’m gonna delete this thread so not to confuse anyone else, thank you for trying to help, I don’t think I explained what I was after clearly, and that caused more issues.
The index I ended up using was: 'Single field Index, 1 (ASC), unique’ instead of ‘single field index, text, unique’