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