[size=medium][color=blue][b]<if test="creativeName!=null and creativeName!=''">
and ci.creative_name like "%"#{creativeName}"%"
</if>
<if test="title != null">
AND title LIKE CONCAT(CONCAT('%',#{title}),'%')
</if>[/b][/color][/size]
and ci.creative_name like "%"#{creativeName}"%"
</if>
<if test="title != null">
AND title LIKE CONCAT(CONCAT('%',#{title}),'%')
</if>[/b][/color][/size]