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!