Re: MariaDB and MATCH AGAINST Query

[SGK Stmk]

Thanks for your answer. As I've mentioned, it's work in progress - I know it's redundant.

In the meanwhile I've tried in MariaDB:
- dropped the fulltext-index
- changed engine to InnoDB
- changed statement to:

SELECT DISTINCT b.id, b.title, b.shtext, b.lotext
FROM b_entry b, b_category c, b_entry2user eu
WHERE (b.title LIKE '%[searchterm]%' OR b.shtext LIKE '%[searchterm]%' OR b.lotext LIKE '%[searchterm]%')
AND b.archive = 0
AND (
(b.categoryId = 4 AND b.id = eu.entryId AND eu.userId = [id])
OR (b.categoryId = c.id AND c.parentId = 3 AND b.id = eu.entryId AND eu.userId = [id])
OR (b.categoryId = c.id AND c.parentId = 2)
OR (b.categoryId = c.id AND c.parentId = 1)
);

I use a searchterm that is definitely part of several varchar-fields used in the statement. But I still get an empty result... don't know what's wrong here?!