[Archivesspace_Users_Group] Deleting duplicate commas - MySQL woes

[Danielle Butler]

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

www.butlercenter.org<http://www.butlercenter.org/>

100 Rock Street

Little Rock, AR 72201

501-320-5724


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20181220/a4210a5e/attachment.html>