title: is that possible to count how many rows between two rows mysql?
body: <p>I have a mysql table like below. I want to count how many rows between berry and strawberry, in my case is 2 rows between these two fruits. How can I achieve that?</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>id   fruit
  1     apple
  2     berry
  3     banana
  4     pineapple
  5     strawberry</code></pre>
  </div>
  </div>
  </p>