mybatis not in

MyBatis is a popular Java-based persistence framework that provides support for mapping SQL queries to Java objects. The "NOT IN" clause is a feature of SQL, not directly related to MyBatis.

To use the "NOT IN" clause in your MyBatis query, you can utilize the `<foreach>` tag in combination with the SQL fragment. Here's an example:

<select id="getUsers" resultType="User">
  SELECT * FROM users
  WHERE id NOT IN
  <foreach item="item" collection="idList" open="(" separator="," close=")">
    #{item}
  </foreach>
</select>

In this example, `idList` is a parameter passed to the query containing the list of IDs to exclude from the result. The `<foreach>` tag iterates over the `idList` and constructs the "NOT IN" clause dynamically.

You can customize this example based on your specific requirements and adjust the query accordingly. Remember to define the `idList` parameter in your mapper interface or XML file.

I hope this helps! Let me know if you have any further questions.