mybatis select if

In MyBatis, you can use the `<if>` element to conditionally include a portion of the SQL statement in your select query. Here's an example of how to use it:

<select id="getUser" resultType="User">
  SELECT * FROM users
  WHERE 1=1
    <if test="id != null">
      AND id = #{id}
    </if>
    <if test="name != null">
      AND name = #{name}
    </if>
</select>

In the above example, the `<if>` element is used to check if the `id` and `name` parameters are not null. If they are not null, the corresponding conditions will be added to the SQL statement.

You can customize the conditions inside the `<if>` element based on your requirements. The `<if>` element allows you to dynamically build your SQL queries based on the input parameters.