MySQL Forums
Forum List  »  Full-Text Search

Re: partial word search with FULLTEXT
Posted by: Dhilip Swaminathan
Date: July 29, 2021 05:10AM

Did you find a solution for this?
I am facing same problem and dont find a way to search based on single character using MySql Full text search.

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

Written By
March 04, 2021 12:28AM
Re: partial word search with FULLTEXT
July 29, 2021 05:10AM

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.