ebusiness中后台拼凑like的sql语句代码写法

//1. conditions += "AND (lower(agentCode) like '%"+fieldValue.toLowerCase()+"%' or lower(agentName) like '%"+fieldValue.toLowerCase()+"%')";
//2. 1=1 AND (prpDregion.regionCName = '荷属安地列斯群岛') 
3. conditions += "AND (prpDregion.regionCName like '%"+ destination +"%')";