and pidname="yidong" and ( substring(cardname,-2,2)%11 = 0 and substring(cardname,-4,2)%11 = 0  and substring(cardname,-2,2) != substring(cardname,-4,2)  ) and  cardname not like '4%' and cardname not like '7%' and cardname like "9999%"