setting authors.name to authors.sort
I wanted my author names to be the same as the sort field. I didn't see a way in Calibre to do this en masse, so used sqlite3 to do
update authors set name=sort;
The data looked correct, but in the main screen of calibre, all the author names showed up as "Lastname & Firstname" rather than "Lastname, Firstname". If I edit the metadata of an individual book, Calibre correctly shows "Lastname, Firstname" in the author field. It's only on the main screen that the "&" shows up as a separator.
How can I get the author name to be the same as the author sort field?