17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT T.createtime ,to_char(t.phones) ,T.message
FROM mall_sms_apply T
WHERE length(T.phones)<1000
AND '15878000000' IN (SELECT '全部' FROM DUAL UNION ALL SELECT to_char(w.phones)
FROM mall_sms_apply W WHERE length(w.phones)<1000
and to_char(W.phones)= to_char(t.phones)) ;