title: Replace new line from the end of string SQL and update columns
body: <p>I have a table called <strong>Players</strong> with two columns <strong>Name</strong> and <strong>PlayerID</strong>. I am using <strong>SQLite</strong> under <em>DB Browser for SQLite</em>.</p>
  <p>Unfortunately, all my player's names have a something like a &quot;\n&quot; (a newline) at the end of their <strong>Name</strong>.</p>
  <p>Ex:</p>
  <pre><code>&quot;Mark
  &quot;
  </code></pre>
  <p>I tried to use Update &amp; Replace for all the names with the following query (I have like 450 rows in the table):</p>
  <pre><code>UPDATE Players
  SET Name = REPLACE(Name,CHAR(10),'')
  WHERE PlayerID &lt;= 500
  </code></pre>
  <p>When I execute something like:</p>
  <pre><code>SELECT * FROM Players
  WHERE Players.Name LIKE 'Mark'
  </code></pre>
  <p>it'll return no rows because of the end line. Here 'Mark' has no &quot;\n&quot;, so it won't be found.</p>
  <p>If I execute:</p>
  <pre><code>SELECT * FROM Players
  WHERE Players.Name LIKE 'Mark
  '
  </code></pre>
  <p>it will return my player. (after Mark I pressed enter)</p>
  <p>I want to change all my rows from this format</p>
  <pre><code>&quot;Mark
  &quot;
  </code></pre>
  <p>to this</p>
  <pre><code>&quot;Mark&quot;
  </code></pre>
  <p>and save all the changes.</p>
  <p>How can I solve my problem? What's wrong?</p>