title: Selecting Sequential records
body: <pre><code>CREATE TABLE `sequence` (`id` int(11) NOT NULL auto_increment, `load_status` varchar(100) default NULL, PRIMARY KEY  (`id`));
  INSERT INTO `sequence` VALUES (1,'success'),(2,'success'),(3,'success'),(4,'fail'),(5,'success');
  
  mysql&gt;select * from sequence;
  +----+-------------+
  | id | load_status |
  +----+-------------+
  |  1 | success     | 
  |  2 | success     | 
  |  3 | success     | 
  |  4 | fail        | 
  |  5 | success     | 
  +----+-------------+
  5 rows in set (0.00 sec)
  </code></pre>
  
  <p>I want all the status where "success" is displayed sequentially. The ID's 1,2 and 3 will be returned. But the ID 5 will not be selected unless it is followed by another success.</p>