SQL(ite) question
Richard Gaskin
ambassador at fourthworld.com
Tue Jan 14 17:05:23 EST 2020
Bob Sneidar wrote:
> Yes, but the original question was about whether or not it could be
> done with a single statement. Also I am not a big fan of full text
> searches the way they are implemented typically. For instance, on our
> copier vendor's websites they of course have searches, but what I end
> up with are 10,000 hits and almost none of them relevant. This is
> because they are not ranked, and the ranking makes all the difference
> in the world.
>
> My method does not rank of course, but it is a quick one liner that
> gets the job done (unless you have to build the query on the fly in a
> repeat loop).
SQLite's FTS is described as providing ranking. Maybe they were using
an older version, or not using the full API?
--
Richard Gaskin
Fourth World Systems
Software Design and Development for the Desktop, Mobile, and the Web
____________________________________________________________________
Ambassador at FourthWorld.com http://www.FourthWorld.com
More information about the use-livecode
mailing list