本文共 952 字，大约阅读时间需要 3 分钟。

???Oracle?MySQL?MSSQL????create_by????????

???

???????????????????create_by????????????????????????????????????????????????create_by????????

??????????create_by??????????????????????????????????????create_by?????????????????????????????

2. ???????

??????????create_by??????????????????????????????????????????????

3. ?????????

????????????????????????????????

• Oracle????

WHERE create_by IN (    SELECT u.id as "CREATE_BY_ID"    FROM sys_user u    WHERE u.name LIKE '%'||#{createBy.name}|| '%')

• MSSQL????

WHERE create_by IN (    SELECT u.id as "CREATE_BY_ID"    FROM sys_user u    WHERE u.name LIKE '%'+#{createBy.name}+'%')

• MySQL????

WHERE create_by IN (    SELECT u.id as "CREATE_BY_ID"    FROM sys_user u    WHERE concat(u.name, '%') LIKE '%#{createBy.name}%')

4. ???????

?????????????????????????????????????????????????????????

5. ??????

??????????????????????????????????????????????????????????

???????Oracle?MSSQL?MySQL???????????????create_by????????

转载地址：http://ripfk.baihongyu.com/