Not the answer you need?
Register and ask your own question!

Fulltext indexing search results inaccurate

hillerhiller ContributorInactive User Role Novice
MariaDB [test]> select body from t3 where body like '%admin%';
+
+
| body |
+
+
| admin |
| tsdadmin |
| 121admin |
+
+
3 rows in set (0.07 sec)


MariaDB [test]> SELECT body FROM t3 WHERE MATCH(body) AGAINST('(*,*admin*)' IN BOOLEAN MODE);
+
+
| body |
+
+
| admin |
+
+
1 row in set (0.00 sec)

How to solve?I want fulltext indexsearch results,with like '%%' results are consistent.

thanks!
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.