Modify "Find It" feature to treat search terms as AND, not OR.

[eric-gilbertson]

Currently find it returns items that contain any of the words in the user entered phrase, eg searching for "Take off my dress" returns all items that contain the word dress instead of the Ana Egge song of that name. The utility of this feature would be greatly increased if it returned only items that contained all the user entered words.

[RocketMan]

Actually, looking at the code just now, it is already doing an AND, not an OR.

As proof, type White. See the results. Then White Horse. Notice you have fewer, not more results.

In your example, 'take off my dress', everything is a stopword except for 'dress'. If you put that phrase in double quotes, it will find just your playlists with 'take off my dress', but if you just type it as-is, you get a list of things which match 'dress'.

(I'm not sure why 'take' is being treated as a stopword; I am going to look into that further.)

So bottom line, Find It! already does AND not OR.

[RocketMan]

(I'm not sure why 'take' is being treated as a stopword; I am going to look into that further.)

'Take' is, in fact, a stopword:
https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html#fulltext-stopwords-stopwords-for-myisam-search-indexes

[RocketMan]

Given that we already do AND and not OR, shall we close this?

Or do you want to keep it open and revisit the stop lists? I am gobsmacked how many words are in there, that in our case, probably should not be. Zk is not a huge database, so I don't think indexing things like 'take' or 'besides' or any of a number of words of that sort will cause us undue strain.

[RocketMan]

I have a prepared a significantly reduced stopword list and am tracking in #176

To minimize any possible disruption, I will defer restarting mysqld and rebuilding the indexes until tomorrow morning after midnight.

[RocketMan]

OK, after the ops changes of #176, you will find that your sample phrase, 'take off my dress', even WITHOUT the quotation marks now yields a much more reasonable result:

NOTE: Now, the only stopword in the phrase is 'my', so you do get some extra things like 'take off your dress'. (Previously, everything was a stopword except for dress).