Quote:
Originally Posted by Starson17
I'm not certain I understand you, but I think you want to find books where the comments field has content, but not much content. I suspect you need the len() function. I'm pretty sure you can't do that with search. You might be able to do it by creating a custom column, but a quick check through the functions available didn't turn up len. I suspect we need Charles the guru for this one.
|
If you have SQLite Database browser installed. the query seems to work on metadata.db to get the index#
Code:
Select books.title,comments.text from comments,books where length(text)<25 and comments.id=books.id
I used a value of 25 for 5 words of 5 chars (inc spaces)