How to write a MyBatis fuzzy query statement?

2 years ago
William Carter
1 minute

The fuzzy query statement in MyBatis can be implemented using the KEYWORD LIKE. The specific syntax is as follows:

  1. Define a method for fuzzy searching in the Mapper file, for example:
<select id="selectByKeyword" resultType="yourResultType">
    SELECT * FROM your_table
    WHERE your_column LIKE CONCAT('%', #{keyword}, '%')
</select>
  1. Define the mapping of this method in the corresponding Mapper interface, for example:
public interface YourMapper {
    List<YourResultType> selectByKeyword(String keyword);
}
  1. Pass in the keyword for fuzzy search when calling this method, for example:
List<YourResultType> result = yourMapper.selectByKeyword("yourKeyword");

In this way, simple fuzzy querying can be achieved. When using a LIKE query, it is important to note that the keyword should be surrounded by % symbols to indicate a fuzzy match.

bannerAds