Unable to do Full Text Search by Character
I am trying to do a full text search in a Aurora MySQL database table. But it is not working if I try to do search based on single character. For ex:
if I type "e", it should return
noodle, eagle, simple, beach
Here is the sql query for it.
SELECT * FROM Property
WHERE MATCH (PropertyName,OwnerEntityName)
AGAINST ('e*' In Boolean Mode);
I have read in few search results, i have to configure ngram_token_size = 1
but i dont know where to configure it in Aurora MySql .
Any help on this would be appreciated.
Subject
Views
Written By
Posted
Unable to do Full Text Search by Character
372
July 29, 2021 05:11AM
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.