How to use full-text search under mysql+mybatis

The first step is to click full text search full text type index on the column you need full text search. Note that in my example the column is a longText type column

The first step is to create a fulltext type index as shown below

Select full text as the index type

The second step:

Verify whether the full text search sql is good So

Step 3:

I use the mybatis framework and change the automatically generated example condition settings and mapper.xml file content

#

Page<TLog> page = (Page<TLog>) logMapper.selectByExample(tLogExample);

The final sql statement generated by the mybatis framework basically uses the full-text search syntax

Note that the premise of using the full-text search function in mysql is to use the column to be full-text searched Establish a full text type index

The final sql statement generated by the mybatis framework basically uses the full-text search syntax

select id, log_type, system_name, visit_time,message from t_log WHERE ( MATCH (message) AGAINST ('*FA9X0D00000001*' IN BOOLEAN MODE ) )

The above is the detailed content of How to use full-text search under mysql+mybatis. For more information, please follow other related articles on the PHP Chinese website!