Re: MariaDB and MATCH AGAINST Query

[SGK Stmk]

Just in the case anyone needs it sometime, this is my solution for now. Had to change things mentioned in my last posting and to work with subqueries. As a bonus I have added a bit of ranking...

SELECT DISTINCT id, title, shtext, lotext,
((case when title like '%[searchterm]%' then 1 else 0 end) +
(case when shtext like '%[searchterm]%' then 1 else 0 end) +
(case when lotext like '%[searchterm]%' then 1 else 0 end)) as priority
FROM b_entry
WHERE (title LIKE '%[searchterm]%' OR shtext LIKE '%[searchterm]%' OR lotext LIKE '%[searchterm]%')
AND archive = 0
AND (
id IN (SELECT b.id FROM b_entry b, b_category c, b_entry2user eu WHERE b.categoryId = 4 AND b.id = eu.entryId AND eu.userId = [id])
OR id IN (SELECT b.id FROM b_entry b, b_category c, b_entry2user eu WHERE b.categoryId = c.id AND c.parentId = 3 AND b.id = eu.entryId AND eu.userId = [id])
OR id IN (SELECT b.id FROM b_entry b, b_category c WHERE b.categoryId = c.id AND c.parentId = 2)
OR id IN (SELECT b.id FROM b_entry b, b_category c WHERE b.categoryId = c.id AND c.parentId = 1)
) ORDER BY priority DESC, edited DESC, stored DESC;