title: MySQL TRIM leading space in order by clause issue
body: <p>Hi everyone this is simple thing to solve but could not find a way out. I want to apply <code>ORDER BY</code> on a <code>name field</code> which have leading space in some values because of that <code>ORDER BY</code> does not produce the desired results. So I apply <code>TRIM</code> in <code>ORDER BY CLAUSE</code></p>
  
  <pre><code>SELECT * FROM AssetManufacturerName ORDER BY TRIM(AssetManufacturerName)
  </code></pre>
  
  <p>But this still does not produce desired output as shown below. Because of leading spaces <code>Lenovo</code> is on top. I want it to be on 2nd.</p>
  
  <p><a href="https://i.stack.imgur.com/QBvpE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QBvpE.png" alt="Query Result"></a></p>
  
  <pre><code>Sample Table
  +-------------+----------------+
  |    ID       |     Name       |
  +-------------+----------------+
  |    01       | ' Robert King' |
  |             |                |
  |    02       | 'Arsim Kip'    |
  +-------------+----------------+
  </code></pre>
  
  <p>I gone thorough this <a href="https://stackoverflow.com/questions/3480311/mysql-remove-space-before-order-by-clause">question</a> but no joys. I thinks this is MYSQL version issue. </p>
  
  <blockquote>
    <p>NOTE: Our Application is working on MYSQL 5.5.52.</p>
  </blockquote>