title: wildcard for number in MySQL Query?
body: <p>I have following rows in my database table,</p>
  
  <pre><code>number:
  
  1
  2
  3
  4
  100
  101
  102
  103
  104
  200
  201
  202
  </code></pre>
  
  <p>I want to get output of all 100's like[100,101,102,103,104], but i have tried following codes,</p>
  
  <pre><code>SELECT * FROM table WHERE number RLIKE '[[:&lt;:]]1';
  </code></pre>
  
  <p>it shows [1,100,101,102,103,104]</p>
  
  <pre><code>SELECT * FROM table WHERE number LIKE '1%';
  </code></pre>
  
  <p>it shows [1,100,101,102,103,104], i only want get number from 100 to 104, i don't want number 1.</p>