Fulltext and Numbers

Asked

Viewed 20 times

0

I have a search table with a Fulltext index.

When I search for a word, e.g.: technology, it searches normal.

But if you look for a number, example 8530. it returns nothing.

mysql

  • The index only interferes with the return time in the search, not the returned results, so it is not the fault of the index Fulltext. Put examples of your queries that work and don’t work. And welcome to Stackoverflow, it would be interesting if you read the tour en.stackoverflow.com/tour to better understand the functioning of the website.

  • Thank you Daniel! I managed to solve the problem. The issue is that LONGTEXT and MEDIUMTEXT fields are not indexed as Fulltext in the version of Mysql you were using.

  • But this problem with index influenced the return of a select?

1 answer

0

I managed to solve the problem. The issue is that LONGTEXT and MEDIUMTEXT fields are not indexed as Fulltext in the version of Mysql I was using.

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.