<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:rgb(0,0,0); font-family:"Calibri Light","Helvetica Light",sans-serif,EmojiFont,"Apple Color Emoji","Segoe UI Emoji",NotoColorEmoji,"Segoe UI Symbol","Android Emoji",EmojiSymbols">
<div style="">
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif">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. </span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif"><br>
</span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif">I was given a command for an older MySQL server version, and modified it using the MySQL Server v. 8 manual.</span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif"></span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif">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. </span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif"><br>
</span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif">Does anyone see an apparent issue with my syntax that I'm missing? Again, these commands are for v. 8. </span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif"><br>
</span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif"></p>
<p style="color: rgb(33, 33, 33); font-size: 11pt; font-family: Calibri, sans-serif, serif, EmojiFont; margin-right: 0px; margin-left: 0px;">
<span style="color: rgb(0, 119, 170); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">REPLACE</span><span style="color: black; font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248);"> </span><span style="color: rgb(0, 119, 170); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">INTO</span><span style="color: black; font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248);"> archival_object </span><span style="color: rgb(0, 119, 170); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">VALUES</span><span style="color: black; font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248);"> </span><span style="color: rgb(153, 153, 153); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">(</span><code style="font-family: "Courier New";"><span style="color: rgb(47, 57, 65); font-size: 9pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 249, 249); padding: 0px; border: 1pt solid rgb(233, 235, 237);">display_string</span></code><span style="color: rgb(47, 57, 65); font-size: 10.5pt; font-family: "Segoe UI", sans-serif, serif, EmojiFont;"> </span><span style="color: rgb(153, 153, 153); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">,</span><span style="color: black; font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248);"> </span><span style="color: rgb(102, 153, 0); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">',,'</span><span style="color: rgb(153, 153, 153); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">,</span><span style="color: black; font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248);"> </span><span style="color: rgb(102, 153, 0); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">','</span><span style="color: rgb(153, 153, 153); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">);</span><span style="color: black; font-size: 12pt; font-family: "Calibri Light", sans-serif, serif, EmojiFont;"></span></p>
<p style="color: rgb(33, 33, 33); font-size: 11pt; font-family: Calibri, sans-serif, serif, EmojiFont; margin-right: 0px; margin-left: 0px;">
<span style="color: rgb(0, 119, 170); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">SELECT</span><span style="color: black; font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248);"> </span><span style="color: rgb(221, 74, 104); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">TRIM</span><span style="color: rgb(153, 153, 153); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">(</span><span style="color: rgb(0, 119, 170); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">TRAILING</span><span style="color: black; font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248);"> </span><span style="color: rgb(102, 153, 0); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">','</span><span style="color: black; font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248);"> </span><span style="color: rgb(0, 119, 170); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">FROM</span><span style="color: black; font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248);"> </span><span style="color: rgb(102, 153, 0); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">'title'</span><span style="color: rgb(153, 153, 153); font-size: 9.5pt; font-family: Consolas, serif, EmojiFont; background-color: rgb(248, 248, 248); padding: 0px; border: 1pt none windowtext;">);</span></p>
</span>
<p></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif"><br>
</span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif">Thanks for any advice you can give, </span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif"><br>
</span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<a name="_MailAutoSig" id="LPlnk575980" class="OWAAutoLink" previewremoved="true"><span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif; color:#1F4E79">Danielle Butler, CA | Archivist</span></a></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style=""><span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif">Butler Center for Arkansas Studies | Central Arkansas Library System
</span></span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style=""></span><a href="http://www.butlercenter.org/" id="LPlnk320163" class="OWAAutoLink" style="color:rgb(5,99,193); text-decoration:underline" previewremoved="true"><span style=""><span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif">www.butlercenter.org</span></span><span style=""></span></a><span style=""><span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif">
</span></span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style=""><span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif">100 Rock Street</span></span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style=""><span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif">Little Rock, AR 72201</span></span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style=""><span style="font-size:12.0pt; font-family:"Calibri Light",sans-serif">501-320-5724</span></span></p>
<span style=""></span>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</p>
</div>
</div>
</body>
</html>