steve mtangoo wrote:
> I have a script that is supposed to query the Bible scriptures between two
> intervals. My table is named Bible and have columns: ID (int), Book (int),
> Chapter(int), Verse (int) and Scripture(text).
>
> Now the books are unique i.e. 1-66 but chapters keep repeating, and so do
> verses. Now suppose I want to get scripture between book 1 chapter 1 verse 1
> and book 2 chapter 3 Verse 1, how do I go about?
SELECT Scripture
FROM Bible
WHERE
Book > 0 AND Book < 3 AND
Chapter > 0 AND Chapter < 4 AND
Verse > 0 AND Verse < 2
> My knowledge of SQLite3
> have taken me to a dead end!
You need to acquire knowledge of SQL, not sqlite3. Google for tutorials.
>
> You can check how bible have its chapters and verses arranged at
> www.biblegateway.com.
>
> Thanks!
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Puneet Kishor
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
