MySQL Forums
Forum List  »  Full-Text Search

fulltext search with "AND" no results
Posted by: Blaat Schaap
Date: January 18, 2018 05:18AM

hey guys,

in germany, the word "und" means "and".

translated example:

if i have a table "books" and a colun "title", i have a book with title
"hunde und katzen" ( => dogs and kats)

my query is

select * from books where match(title) against ('und'); // no results
select * from books where match(title) against ('hunde'); // working

i tried boolean mode, natural language mode etc. it seems like the word "und"
is not indexed or something, maybe because it means AND and is not indexed?

any ideas?

Options: ReplyQuote


Subject
Views
Written By
Posted
fulltext search with "AND" no results
1857
January 18, 2018 05:18AM


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.