title: MySql - combine REGEXP and BETWEEN functions
body: <p>I have this table.</p>
  
  <pre>
  +--------+----------------+
  | id     | e_id           |
  +--------+----------------+
  | 164462 | " 3 1 2 4 6 "   |
  | 164463 | " 185 1 2 4 6 " |
  | 164464 | " 3 1 2 1140 6 "|
  | 164465 | " 52 1 2 4 6 "  |
  | 164466 | " 3 1 175 4 6 " |
  | 164467 | " 3 1 2 4 6 "   |
  | 164468 | " 3 1 2 4 6 "   |
  | 164469 | " 3 1 2500 4 6 "|
  | 164470 | " 82 1 2 4 6 "  |
  | 164471 | " 3 1 2 4 6 "   |
  | 164472 | " 3 1 50 4 6 "  |
  | 164473 | " 3 1 2 4 6 "   |
  +--------+-----------------+</pre>
  
  <p>I must find that rows that contains numbers between 175 and 2574, but numbers are separated just with <code>[[:space:]]</code>.</p>
  
  <p>I was tried to use mysql query like this:<br/></p>
  
  <pre><code> select * 
     from table_name 
     where e_id between REGEXP '[[:space:]]175[[:space:]]' 
       and  REGEXP '[[:space:]]2574[[:space:]]';
  </code></pre>
  
  <p>...and a lot of combination like this one, but no luck...</p>
  
  <p>Thanks For Help!:)</p>