some artists change names completely
In Brian's step 2, you can include a list of completely different names in the search criteria if you know what all the alias' are. For example, a search such as;
[Artist]=Clapton,[Eric",Baza,"ton]
Means: The Artist Name contains 'Clapton" or begins with 'Eric' or contains 'Baza' or ends with 'ton'.
Be careful of the spaces though, because the following Search Expression;
[Artist]=Clapton, [Eric",Baza,"ton]
Means: The Artist Name contains 'Clapton"
and either begins with 'Eric' or contains 'Baza' or ends with 'ton'.
The extra space after 'Clapton,' makes a difference. Most of that is documented in the Wiki here:
https://wiki.jriver.com/index.php/Search_Language#Grouping_and_CombiningThe same search can also be performed using;
[Artist]=Clapton,([Eric",Baza,"ton])
No space, but the brackets () mean that those criteria get evaluated first, even though they are not first in the list reading left to right, and then the first criteria, 'Clapton' gets evaluated last, and as an OR statement.
Make sure to read all that Wiki article, including the:
https://wiki.jriver.com/index.php/Search_Language#Quoting_and_AnchoringThe extra space bit doesn't seem to be documented in the Wiki, but it works.The example in the Wiki;
[Artist]=[Bob Dylan] ([Date (year)]=1969 or [Date (year)]=1997)
can also be expressed, and works identically, to;
[Artist]=[Bob Dylan] [Date (year)]=1969,1997
Neat. But I digress just a little. The point is that you can include a list of all known Alias' in one search, and deal with all the name variations in one go. Knowing how the MC Search Language works just makes it a lot easier.
so I wanted old names to be matched to new names but I don't think that's possible. It's not like I can make a database record that artist links to lol.
You can actually create a List Type field in MC to contain all the Alias' and theoretically you can make that field Relational to the [Artist] field, so that there can be only one set of Alias values for each [Artist] value. But when I did a little testing of that some time back, from memory the List Type caused the Relational status not to work, so updates didn't happen. But you could have a String Type field containing the Alias' just for reference, and it would be updated for all files any time you added a new Alias, if the [Alias] field was Relational to the [Artist] field.
But as Brian says, that is more work than just fixing the problem in the first place.