Like this
SELECT * FROM TEST_TBL
WHERE
    (FIRST_NAME, LAST_NAME) IN (
        ('Yamada', 'Taro'),
        ('Suzuki', 'Jiro')
    )
It's useless if you do it normally, so I'll do my best with a for statement.
SELECT * FROM TEST_TBL
WHERE
    (FIRST_NAME, LAST_NAME) IN (
        /*%for condition : conditionList */
            (/* condition.firstName */'firstname', /* condition.lastName */'lastname')
            /*%if condition_has_next */
                ,
            /*%end */
        /*%end */
        /*%if conditionList == null || conditionList.isEmpty() */
            (NULL, NULL)
        /*%end */
    )
        Recommended Posts