title: SQL: ORDER BY using a substring within a specific column... possible?
body: <p>I have a database whose columns are npID, title, URL, and issue.</p>
  
  <p>Here is an example of two years' entries:</p>
  
  <pre><code>npID               title               URL               issue
  88                 EMR Newsletter      a.com             2010 Third_Quarter
  89                 EMR Newsletter      b.com             2010 Second_Quarter
  43                 EMR Newsletter      c.com             2010 First_Quarter
  47                 EMR Newsletter      d.com             2009 Winter
  45                 EMR Newsletter      e.com             2009 Summer
  46                 EMR Newsletter      f.com             2009 Spring
  44                 EMR Newsletter      g.com             2009 Fall
  </code></pre>
  
  <p>What I would like to do is be able to sort the results based on substrings within the "issue" column.  However, until 2010, the client used seasons as the header and in 2010, they started using quarters.  Is there a way in the "ORDER BY" I can provide a list of words to sort by if/when they're found anywhere in the "issue" value?</p>
  
  <p>I would like the end result to be something like this:</p>
  
  <pre><code>npID               title               URL               issue
  43                 EMR Newsletter      c.com             2010 First_Quarter
  89                 EMR Newsletter      b.com             2010 Second_Quarter
  88                 EMR Newsletter      a.com             2010 Third_Quarter
  47                 EMR Newsletter      d.com             2009 Winter
  45                 EMR Newsletter      e.com             2009 Summer
  46                 EMR Newsletter      f.com             2009 Spring
  44                 EMR Newsletter      g.com             2009 Fall
  </code></pre>