title: How does MySQL handle exotic between statements
body: <p>I have a between case, where the expression is not a calculation nor a field. 
  Somehow this is valid SQL and the results with different permutations for this kind of system, gives different results.</p>
  
  <p>I have tried to figure out what MySQL does, but I couldnt make out any pattern nor any sense.</p>
  
  <p>Here is the example Query:</p>
  
  <pre><code>SELECT 
  *
  FROM
  &lt;table&gt;
  WHERE
  status = 'test'
  BETWEEN
  2 AND
  'test';
  </code></pre>
  
  <p>Feel free to replace the values and data types.</p>
  
  <p>I would appreciate a hint to what could happen here exactly.</p>