On 19 May 2015, at 6:39pm, Adam Podstawczy?ski <adam at podstawczynski.com>
wrote:
> Now, the above query is expected to return one record only
Please check your post. The line you say is returned is not in the data you
included in your post.
Here's your data in a readable form to work with:
CREATE TABLE list_of_numbers (
nn TEXT,
astart INT,
aend INT,
alength INT,
usesflag TEXT,
blength INT,
coolflag NUM,
alphaid
);
INSERT INTO list_of_numbers VALUES
('1','7017000000','7017009999','9','Y','10','0','1b9633407507819ni');
INSERT INTO list_of_numbers VALUES
('1','7017070000','7017039999','9','Y','10','0','1b6033960773078ni');
INSERT INTO list_of_numbers VALUES
('1','7017040000','7017059999','9','Y','10','0','1b9633407507819ni');
INSERT INTO list_of_numbers VALUES
('1','7017060000','7017069999','9','Y','10','0','1b6033960773078ni');
INSERT INTO list_of_numbers VALUES
('1','7017070000','7017079999','9','Y','10','0','1b6033939751871ni');
INSERT INTO list_of_numbers VALUES
('1','7017080000','7017099999','9','Y','10','0','1b9633407507819ni');
select * from list_of_numbers where astart < 7169319380 and aend > 7169319380;
Simon.
