title: Get results that are between (inclusive) A and D
body: <p>I am trying to figure out how to do a mysql query where I return results that start with (eg.) A-D, aka would return:
   - animal
   - bank
   - coke
   - dog
  but not: igloo</p>
  
  <p>Seems pretty simple but can't figure out an efficient way to do it.</p>
  
  <p>I mean I can get it based on one letter:</p>
  
  <pre><code>SELECT * FROM table WHERE word LIKE 'A%'
  </code></pre>
  
  <p>but how could I do this with multiple letters easily. I considered a loop 'incrementing the letter from A to D but that doesn't make much sense with letters. Thoughts?</p>