The field help for the 'Recorded by' field of Advanced Search (to match the field elsewhere known as 'Collector'!) says "Enter all or part of the name". This should correspond to a double-wildcard match e.g. '*Broomfield*' (or in SQL: '%Broomfield%') but it doesn't:

- If a single name is entered it finds only exact matches of the whole name. e.g. 'Broomfield'.

- If 'Mary Broomfield' is entered it unexpectedly finds all 'Broomfield' but not all 'Mary'! i.e. it finds all of "Mary Broomfield", "J. Birchall;Mary Bloomfield", "Broomfield, Mary", "M. Broomfield", "Rachel Bloomfield" and more. I would logically expect it to find only the first and second of these.

- If 'Broomfield, Mary' is entered it unexpectedly finds all names containing soundex-style variants of 'Mary' such as "Marie", "Anne-Marie". This is really unhelpful!

- If wildcard '%' characters are explicitly added to the search string it fails to find anything.

I think this field is being over-processed to try matching both name orders and causing serious confusion.