[Archivesspace_Users_Group] Deleting duplicate commas - MySQL woes
dbutler at cals.org
Thu Dec 20 18:26:47 EST 2018
We’re trying to get rid of duplicate commas in our data in component descriptions. We manually included commas when we were using Archivists' Toolkit, and we migrated all of that data. Now we'd like to clean it up so that every description doesn't have two commas if we were to ever more to the PUI.
I was given a command for an older MySQL server version, and modified it using the MySQL Server v. 8 manual.
I believe this is the appropriate way to format the command, but I am getting syntax errors on the first command. I've scoured the manual and can't sort out what is causing the error.
Does anyone see an apparent issue with my syntax that I'm missing? Again, these commands are for v. 8.
REPLACE INTO archival_object VALUES (display_string , ',,', ',');
SELECT TRIM(TRAILING ',' FROM 'title');
Thanks for any advice you can give,
Danielle Butler, CA | Archivist
Butler Center for Arkansas Studies | Central Arkansas Library System
100 Rock Street
Little Rock, AR 72201
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Archivesspace_Users_Group