title: SQL - SQLite count consecutive numbers
body: <p>I have a table with the following data:</p>
  
  <pre><code>id | numbers | date
  ----------------------------------
  1  | -1-4-6- | 2009-10-26 15:30:20
  2  | -1-4-7- | 2009-10-26 16:45:10
  3  | -4-5-8- | 2009-10-27 11:21:34
  4  | -2-6-7- | 2009-10-27 13:12:56
  5  | -1-3-4- | 2009-10-28 14:22:14
  6  | -1-2-4- | 2009-10-29 20:28:16
  .  . ....... . ...................
  </code></pre>
  
  <p>In this example table I use a <code>like</code> query to count numbers, example:</p>
  
  <pre><code>select count(*) from table where numbers like '%-4-%'
  Result: 5
  </code></pre>
  
  <p>Now, how can I count (using like) how many times a number appears consecutively (in this case the number 4)?
  I mean: the number 4 appears consecutively on id 1,2,3 and 5,6 so I want to get a query with result: 2.</p>