Seems like you need a column for each of your subsets, series, book, sections, chapters. Then index on all 5 columns, or have all 5 values concatenated into a single column and index on that. Not sure what kind of index you could use for the text though. I've always wondered about that. How do you index on a column that can contain many words, like a hypertext index?
I don't know enough about SQL to say if you can aggregate all the results, say all the verses in a chapter using purely SQL queries. Obviously you could with an executable like Runrev or OnRev. Perhaps I don't understand the problem you are describing though. Bob On May 8, 2010, at 6:53 PM, Sivakatirswami wrote: > Any ideas of where to go looking for mangos? > > Sivakatirswami _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
