Assuming you have a table like:
CREATE TABLE tb_foobar
(
id INTEGER PRIMARY KEY,
value INTEGER
);
Containing the following data:
INSERT INTO tb_foobar ( id, value ) VALUES ( 1, 1 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 2, 2 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 3, 3 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 4, 4 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 5, 5 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 6, 6 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 7, 7 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 8, 8 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 9, 9 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 10, 10 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 11, 11 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 12, 50 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 13, 60 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 14, 80 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 15, 100 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 16, 120 );
INSERT INTO tb_foobar ( id, value ) VALUES ( 17, 200 );
You can do something like:
SELECT
id,
value
FROM
tb_foobar
WHERE
value IN ( 1, 2, 5, 7 ) OR
value BETWEEN 11 AND 100;
Output:
| id | value |
|----|-------|
| 1 | 1 |
| 2 | 2 |
| 5 | 5 |
| 7 | 7 |
| 11 | 11 |
| 12 | 50 |
| 13 | 60 |
| 14 | 80 |
| 15 | 100 |
SQLFiddle: link