title: Can SQL IN() Query TAKE OR statement
body: <p>I have a table name data as shown Below. the  column mn runs from 1 to 59 and starts again from 1
  so i have a query that selects 10 interval like this</p>
  
  <pre><code>SELECT * FROM data WHERE mn IN('00','10','20','30','40','50') AND dt='2019-04-20' ORDER BY ID ASC
  </code></pre>
  
  <p>this works fine and give the desired result.
  But for some reason sometimes this wanted data 00,10,20,30 etc are not available i want to be able to pick the next or the one before in place of it.</p>
  
  <p>Lets say 10 is not available i want to be able to pick 09 or 11 in its place, or lets say 20 is not available i want to be able to pick 19 or 21 in its place.
  How can i do this i tried an OR in the IN statement it returned funny result.
  Please any help will be greatly appreciated Thanks</p>
  
  <pre><code>id  mn  dt         status
  ---|---|----------|-----------
   1 |01 |2019-04-20|1    
   2 |02 |2019-04-20|1
   3 |03 |2019-04-20|1    
   4 |04 |2019-04-20|1
   5 |05 |2019-04-20|1    
   6 |06 |2019-04-20|1
   7 |07 |2019-04-20|1    
   8 |08 |2019-04-20|1
   9 |09 |2019-04-20|1    
   10|10 |2019-04-20|1
   11|11 |2019-04-20|1    
   12|12 |2019-04-20|1
   13|13 |2019-04-20|1    
   14|14 |2019-04-20|1
   15|15 |2019-04-20|1    
   16|16 |2019-04-20|1
   17|17 |2019-04-20|1    
   18|18 |2019-04-20|1
   19|19 |2019-04-20|1    
   20|21 |2019-04-20|1
   21|22 |2019-04-20|1    
   22|23 |2019-04-20|1
  </code></pre>