title: MySQL - Using a CASE statement vs. lookup table?
body: <p>I'm debating between using a <code>CASE</code> statement or a lookup table to replace text from <code>table2.columnB</code> when <code>table1.columnB = table2.columnA</code>. I'd rather use a lookup table because it's easier to manage.</p>
  
  <p>Our database pulls all the customer order information from our online store. It receives all the state names in full and I need to replace all instances of U.S. states with their 2-character abbreviation. (e.g. Texas -> TX)</p>
  
  <p>How would I use a lookup table with this query for <code>State</code>?</p>
  
  <p>Here's my query: <a href="http://sqlfiddle.com/#!9/e44aa3/12/0" rel="nofollow noreferrer">http://sqlfiddle.com/#!9/e44aa3/12/0</a></p>
  
  <p>Thank you in advance!</p>