Mysql fulltext search is not returning any rows which is having dot(.)

by Krishnan   Last Updated March 12, 2018 07:06 AM

Here it is not fetching any rows from the table .

My table structure

tb_business

|  business_id  |    title    |
|-----------------------------|
|     1         |   abcd.efg  |
|     2         |   vwxyz     |

Here 'title' is the full text column.

query 1:

select * from  tb_business where MATCH(title) AGAINST("vwxy*" IN BOOLEAN MODE)

result :

|  business_id  |    title    |
|-----------------------------|
|     2         |   vwxyz     |

Here everything is good.

query 2:

 select * from  tb_business where MATCH(title) AGAINST("abcd*" IN BOOLEAN MODE)

But here it is not fetching any rows. showing blank result. I expected the result like

|  business_id  |    title    |
|-----------------------------|
|     1         |   abcd.efg  |

How do i solve this ?



Related Questions


Search functionality using joins

Updated April 27, 2015 23:02 PM


Mysql: does full-text cover normal index?

Updated October 11, 2017 18:06 PM