sqlite - SELECT column FROM table WHERE number FALL-IN-RANGE-OF-TEXT -

say, have column 'pointer' in table 'mark'. in column, have records (text) follow.

1. 0, 100, 200, 300, 400, 500 2. 500, 600, 700, 800, 900, 1000 3. 1000, 1100, 1200, 1300, 1400, 1500 

is there way select record (text) number (int) fall in range?

there 2 scenarios here.

case 1: given number 250, select should return record 1.

case 2: given number 1000, select should return record 3.

it not possible use sqlite's built-in sql functions extract last number variable-sized list.

you should change table store minimum , maximum values in separate columns; can do

select * mark x between pointermin , pointermax