As stated, I am currently trying to correct any artists name that are having differences in casing. I was just wondering what query should I use?
Eg. the search query will return Namie Amuro and Namie amuro.
Create a Facets UI element with two panes:
(1) $lower(%artist%) column, subitems statistic
(2) %artist% column
Click twice on the subitems column header to sort by subitems in descending order.
Entries with more than one subitem need to be corrected.
Select each entry to see the different spellings in the second pane.