GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Fulltext indexing search results inaccurate

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Fulltext indexing search results inaccurate

    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!

Working...
X