sql - How to match a an exact piece of string with full stop in MySQL Full text search?

Question

I have a table "employee" in Mysql, I decide to use FULL TEXT SEARCH INDEX for this.

employee table has a name column and values are like this

'ramakrishna',
'ramakrishna.hande',
'Ramakrishna.Hande',
'hande'

Now I want to write a query which fetches me 'ramakrishna.hande' and 'Ramakrishna.Hande'.

I wrote

SELECT * FROM employee WHERE MATCH(name) AGAINST("ramakrishna.hande");

But it fetches me everything from above list. I want to avoid this . I am using Scala as the programming language which I am using for executing MySQL query.

Is there a way to solve it ?

question from:https://stackoverflow.com/questions/65847872/how-to-match-a-an-exact-piece-of-string-with-full-stop-in-mysql-full-text-search

Answer 1

Waitting for answers