title: search mysql table after specific id
body: <p>I am working with a TABLE, need logical help.</p>
  
  <p>Check the below URL for the table structure and sample data.</p>
  
  <p><a href="http://sqlfiddle.com/#!2/6da1ce/2" rel="nofollow">http://sqlfiddle.com/#!2/6da1ce/2</a></p>
  
  <p>I am trying to fetch records after a specific value.</p>
  
  <p>Check the following:</p>
  
  <p>My db has the following datas.</p>
  
  <pre><code>Id ---- Value
  1       3
  2       6
  3       7
  4       8
  5       9
  6       2
  7       3
  </code></pre>
  
  <p>I am searching for the value 7, after the appearance of  7 in Id 3, I want to search for the next ID's after that such as 8,9,2,3.</p>
  
  <p>I am trying to write a query to get the records after the first appearance of 7.</p>
  
  <p>I tried the following:</p>
  
  <pre><code>SELECT * FROM TABLE 
  WHERE id &gt; (SELECT id FROM TABLE WHERE value = 7
              limit 1)
  </code></pre>
  
  <p>in my case: </p>
  
  <pre><code>SELECT * from journal 
  WHERE journal_id &gt; (SELECT journal_id from journal WHERE id = 7
                      limit 1)
  </code></pre>
  
  <p>How can I write this in single Query:</p>
  
  <p>I know only the value from where the search should begun.</p>
  
  <p>Can I search using limit instead of mentioning Unique ID? Also can I get the remaining search in DESC order? </p>