On 7/15/2014 10:21 PM, jose isaias cabrera wrote:
SELECT * from startcodes where code = 'e';
but I want to search only from id >= 8 and <= 14.
Just say so:
SELECT * from startcodes where code = 'e' and id between 8 and 14;
I know I
can do a WHERE id BETWEEN 8 AND 14, but is there another faster way?
So you already know the answer. How exactly does it fail to satisfy your
requirements?
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
