select a1.calldate , a1.src , a1.dst ,a1.billsec
, (select accountNumber from poicomcce.customer b1 where a1.dst like "%"+b1.Phone+"%" ) accountNumber
from asterisk.ast_cdr a1
where src in (2602,2615,2636) limit 200红字部份我想要做模糊查询,应该怎样写呢?请指点,谢谢
, (select accountNumber from poicomcce.customer b1 where a1.dst like "%"+b1.Phone+"%" ) accountNumber
from asterisk.ast_cdr a1
where src in (2602,2615,2636) limit 200红字部份我想要做模糊查询,应该怎样写呢?请指点,谢谢
where charindex(b1.Phone,a1.dst) > 0
, (select accountNumber from poicomcce.customer b1 where a1.dst like '%'+b1.Phone+'%' ) accountNumber
from asterisk.ast_cdr a1
where src in (2602,2615,2636) limit 200单引号的吧。你是MYSQL?