I am having a problem with searching a MariaDB database.
Search keywords come from user-input, processed with PHP, SQL query made and results returned.
In it's simplest form :-
CREATE TABLE db ( item_no SMALLINT(6) NOT NULL, item_text MEDIUMTEXT, PRIMARY KEY (item_no), FULLTEXT (item_text)) ENGINE=innodb";
I want to do an AND keyword search, such that more keywords give fewer results. To do this I use the MATCH AGAINST query IN BOOLEAN MODE, putting a '+' prefix to each keyword :-
SELECT item_no FROM db WHERE MATCH (item_text) AGAINST ('+wordone +wordtwo' IN BOOLEAN MODE)
This words fine, as do literal searches :-
SELECT item_no FROM db WHERE MATCH (item_text) AGAINST ('"wordone the wordtwo"' IN BOOLEAN MODE)
... however, if the last example is unquoted as :-
SELECT item_no FROM db WHERE MATCH (item_text) AGAINST ('+wordone +the +wordtwo' IN BOOLEAN MODE)
I get no results. Is it because 'the' is a stopword ?
I am running MariadB 10.3.34 on Linux Mint 20.1.