MySQL Forums
Forum List  »  Full-Text Search

Unable to do Full Text Search by Character
Posted by: Dhilip Swaminathan
Date: July 29, 2021 05:11AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to do Full Text Search by Character
193
July 29, 2021 05:11AM


Sorry, only registered users may post in this forum.

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.