SELECT * FROM DB2ADMIN.SMS_USER_INFO T WHERE length(T.USER_MOBILE)>=6 and T.USER_MOBILE <>'' and locate(T.USER_MOBILE,'"+mobile+"')>0
DB2过滤接收到电话号码的86,在数据库中查找匹配条件的数据
最新推荐文章于 2022-08-08 19:05:24 发布
SELECT * FROM DB2ADMIN.SMS_USER_INFO T WHERE length(T.USER_MOBILE)>=6 and T.USER_MOBILE <>'' and locate(T.USER_MOBILE,'"+mobile+"')>0