title: ORDER BY but make zeroes/nulls last by Adding minus in Order By in Codeigniter
body: <p>I am trying to order by position on my query but set the zero to last. Here is the pseudo code</p>
  
  <pre><code>$this-&gt;db-&gt;select("id,position");
  $this-&gt;db-&gt;order_by('-position', 'ASC' );
  $result = $this-&gt;db-&gt;get( 'SampleTable' );
  </code></pre>
  
  <p>Codeigniter treats the query as </p>
  
  <pre><code>SELECT `id`,`position` FROM `TABLE` ORDER BY `-position` ASC thus having an error
  </code></pre>
  
  <p>Is there any way I can pass the <strong>- minus</strong> so that the query would be </p>
  
  <pre><code>SELECT `id`,`position` FROM `TABLE` ORDER BY -`position` ASC
  </code></pre>