Select a range of integers I have a 'range' of integers (in this case destination ports) that occur: 

For example: 33848-33254.

I want to select 'all' of these without having to do one at a time. is there a range operator? Or should I just use 'between'?
You can use BETWEEN or greater than/less than operators:

select *
from yourtable
where col1 &gt;= 33254 and col1 &lt;= 33848;


or

select *
from yourtable
where col1 between 33254 and 33848;


see SQL Fiddle with Demo