Thank @ all!
Quote:
Originally Posted by theducks
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) |
Thanks, i install SQLite Database browser but i can't use the result.
Because its not all of them shown (i know some books and they will not shown)
------------
Quote:
Originally Posted by chaley
The function you are looking for is count. The following template
Code:
program:cmp(count(field('comments'), ' '), 15, 'true', 'true', 'false')
uses count to generate 'true' if comments contains 15 words or less, and 'false' for more than 15. A word is defined as not-spaces separated by spaces.
You could just as easily use
Code:
program:count(field('comments'), ' ')
in a column with sort/search type 'number', then use the search expression
Edit: If you want the basic length, you can use strlen instead of count. |
Thank you this was i searching for :-)
You does great work.
THX
wkr
Lothar