title: MySQL remove space before order by clause
body: <p>I have a table full of "title" that I want to order by title. Problem is a lot of them have a empty space before the title. I am thinking of writting a php script to fix it all (super easy) but I was curious how could I do:</p>
  
  <pre><code>SELECT * FROM products ORDER BY title
  </code></pre>
  
  <p>But at the same time trimming the title so it doesnt order on the empty space. All in the same query without changing the data. God I hope I make sense.</p>
  
  <p>So I am really looking for a mysql solution to this. For what its worth I use Zend_Db so a solution using that would be even better but I can manage straight MySQL.</p>