title: SQL - How do I filter results with keyword out of normal order and place them at bottom?
body: <p>I have a website I am rebuilding with PHP to read from an Access database. I have most of the functionality for displaying lists of products based on what category from a dropdown is selected. However, one thing I'd like to do is move all the obsolete products to the bottom of the results list. Currently, they are mixed within the displayed results.</p>
  
  <p>Is there a SQL statement that will allow me to do this? Currently, all the obsolete products in the database have "(Obsolete)" appended at the end of their product name. I'm hoping I can target the string (Obsolete) to do this.</p>
  
  <p>Here is my current SQL statement:</p>
  
  <pre><code>$handle = odbc_connect("Potter","","");
  $results = odbc_exec($handle, "SELECT DISTINCT product.prodimage, 
                  product.prodmodelno, 
                  product.proddesc, 
                  product.prodorder, 
                  product.prodpdf, 
                  product.prodmanual, 
                  product.prodtip 
  FROM   product 
  WHERE  (( ( product.prodmodelno ) LIKE '%$searchTerm%' )) 
          OR (( ( product.proddesc ) LIKE '%$searchTerm%' )) 
  ORDER  BY product.prodorder DESC, 
            product.prodmodelno ASC ");
  </code></pre>