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);

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 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!