Mybatis配置文件之动态SQL配置备忘录

  select ID,COMMAND,DESCRIPTION,CONTENT from MESSAGE where 1=1
  
   and COMMAND=#{command}
  
  
   and DESCRIPTION like '%' #{description} '%'
  
 

  delete from MESSAGE WHERE ID = #{_parameter}

 
  delete from MESSAGE WHERE ID in (
  
   #{item}
  
  )