{"id":1098,"date":"2021-10-19T17:06:31","date_gmt":"2021-10-19T15:06:31","guid":{"rendered":"https:\/\/fileidea.com\/?p=1098"},"modified":"2021-10-19T17:06:32","modified_gmt":"2021-10-19T15:06:32","slug":"remove-line-breaks-from-rows-with-sql","status":"publish","type":"post","link":"https:\/\/fileidea.com\/2021\/10\/19\/remove-line-breaks-from-rows-with-sql\/","title":{"rendered":"Remove line breaks from rows with SQL"},"content":{"rendered":"<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n\nUPDATE Person\nSET \nFirstname = REPLACE(REPLACE(Firstname, CHAR(10), '') , CHAR(13), ''),\nLastname = REPLACE(REPLACE(Lastname, CHAR(10), '') , CHAR(13), ''),\n&#x5B;Address] = REPLACE(REPLACE(&#x5B;Address], CHAR(10), '') , CHAR(13), ''),\nCity = REPLACE(REPLACE(City, CHAR(10), '') , CHAR(13), '')\n\nwhere filterOnThis = '8EBE0C5D-4ADC-4DCB-8E59-CF464A94F979'\n<\/pre><\/div>\n\n\n<p>Remove CHAR(10) and CHAR(13).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Remove CHAR(10) and CHAR(13).<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[53,68],"tags":[69],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/fileidea.com\/wp-json\/wp\/v2\/posts\/1098"}],"collection":[{"href":"https:\/\/fileidea.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fileidea.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fileidea.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fileidea.com\/wp-json\/wp\/v2\/comments?post=1098"}],"version-history":[{"count":1,"href":"https:\/\/fileidea.com\/wp-json\/wp\/v2\/posts\/1098\/revisions"}],"predecessor-version":[{"id":1099,"href":"https:\/\/fileidea.com\/wp-json\/wp\/v2\/posts\/1098\/revisions\/1099"}],"wp:attachment":[{"href":"https:\/\/fileidea.com\/wp-json\/wp\/v2\/media?parent=1098"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fileidea.com\/wp-json\/wp\/v2\/categories?post=1098"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fileidea.com\/wp-json\/wp\/v2\/tags?post=1098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}