SELECT * from blog_article a where a.article_id in
    "item" collection="list" index="index" open="(" separator="," close=")">
	#{item.article_id}
    
   and isdel = 0
   order by a.create_time desc,a.update_time desc
select>

  insert into blog_article_label( article_id, label_id ) values
   "list" item="item" index="index" separator="," >
     ( #{item.article_id}, #{item.label_id} )
   
insert>

select * from table
<where>
   "list" item="item" index="index" separator="or">
      name like '%${item}%'
   
where>

  DEKETE  from  blog_article a
  where a.article_id in
   
      #{item}
   

Map map = new HashMap<>();
String[] ids = {"1","2","3"};
map.put("content","修改的內(nèi)容");
map.put("ids",ids);

   UPDATE  table
   SET content="#{content}"
   WHERE id in
   "ids" index="index" item="item" open="(" separator="," close=")">
	#{item} 
   
update>

	UPDATE usr_relation_umbrella
		SET child_number = CASE user_id
		"list" item="item">
			WHEN #{item.userId} THEN #{item.childNumber}
		
		END
	WHERE user_id IN
	"item" collection="list" index="index" open="(" separator="," close=")">
		#{item.userId}
	
update>

UPDATE categories 
    SET display_order = CASE id 
        WHEN 1 THEN 3 
        WHEN 2 THEN 4 
        WHEN 3 THEN 5 
    END, 
    title = CASE id 
        WHEN 1 THEN 'New Title 1'
        WHEN 2 THEN 'New Title 2'
        WHEN 3 THEN 'New Title 3'
    END
WHERE id IN (1,2,3)