ibatis like查询

//Oracle    
SELECT *  FROM Table WHERE  like Column '%'  || #keywords# || '%'  

//mysql
        SELECT *   FROM Table WHERE Column  like CONCAT('%', #keywords#, '%')  

//sqlserver
    SELECT *  
          FROM Table 
          WHERE Column  like '%' + #keywords# +  '%'

 

      

 

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/jcgh/p/2553785.html