How to programmatically use the "between" operator in Drupal Views
I believe you are using hook_views_query_alter. So see the example to add OR in condition. Check out code : 

$this-&gt;query-&gt;add_where(
  $this-&gt;options['group'],
    db_or()
      -&gt;condition($field, array(0, 100), 'BETWEEN')
      -&gt;condition($field, array(150, 200), 'BETWEEN')
  );