Greetings.
Pardon the newbie question, but is there a way to set boundaries on a
search? Imagine this scenario:
startcodes
id,code,date
1,a,2014-08-06
2,b,2014-08-06
3,z,2014-08-06
4,g,2014-08-06
5,g,2014-08-06
6,j,2014-08-06
7,p,2014-08-06
8,t,2014-08-06
9,e,2014-08-06
10,w,2014-08-06
11,w,2014-08-06
12,y,2014-08-06
13,m,2014-08-06
14,o,2014-08-06
15,o,2014-08-06
16,p,2014-08-06
17,u,2014-08-06
18,u,2014-08-06
19,a,2014-08-06
20,a,2014-08-06
SELECT * from startcodes where code = 'e';
but I want to search only from id >= 8 and <= 14. Is there a way to set the
boundary for that SELECT that will only search ids 8-14? I know I can do a
WHERE id BETWEEN 8 AND 14, but is there another faster way?
thanks.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
