Skip to main content

Topic: Search for artist with similar name but different case (Read 678 times) previous topic - next topic

0 Members and 1 Guest are viewing this topic.
  • D.Sync
  • [*][*][*]
Search for artist with similar name but different case
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.

  • Frank Bicking
  • [*][*][*][*][*]
  • Global Moderator
Search for artist with similar name but different case
Reply #1
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.