摘要:
转自:https://www.cnblogs.com/linjiqin/archive/2013/06/24/3152667.html with as语法–针对一个别名with tmp as (select * from tb_name) –针对多个别名with tmp as (select * f 阅读全文
摘要:
1、AND ((USER_NAME LIKE '%'||#{searchKey}||'%') OR (MOBILE_PHONE LIKE '%'||#{searchKey}||'%'))2、 <if test="phone != null and phone != ''"> and MOBILE_P 阅读全文