Re: MariaDB and MATCH AGAINST Query

[Rick James]

The Engine makes a big difference. See http://mysql.rjweb.org/doc.php/myisam2innodb#fulltext

Also, what is the [searchterm] for which you got no results?

This:

(MATCH(b.title, b.shtext, b.lotext) AGAINST('[searchterm]'))
OR (b.title LIKE '%[searchterm]%' OR b.shtext LIKE '%[searchterm]%' OR b.lotext LIKE '%[searchterm]%')
)

does not make sense, since the MATCH should give a subset of the rows that the rest gives. Well, it could give a superset - if plurals are involved. In any case, it is quite redundant and very slow.