MySQL Forums
Forum List  »  Full-Text Search

Re: MariaDB and MATCH AGAINST Query
Posted by: SGK Stmk
Date: August 11, 2016 12:45AM

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?!

Options: ReplyQuote


Subject
Views
Written By
Posted
3682
August 01, 2016 08:30AM
1493
August 02, 2016 06:16PM
Re: MariaDB and MATCH AGAINST Query
1330
August 11, 2016 12:45AM
1332
August 11, 2016 06:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.