select a.issue_date,a.card_no,d.card_type_name,c.*,f.type_name,d.card_type_name,ac.bonus_balance
from card a,rel_member_card b,member c,card_type d,card_status e,idcard_type f,account ac,card_status ca
where a.card_id=b.card_id
and c.member_id=b.member_id
and a.card_type_id=d.card_type_id
and a.card_status_id=e.card_status_id
and c.idcard_type_id=f.idcard_type_id
and ac.account_id=a.account_id
and ca.card_status_id=a.card_status_id
and ca.card_status_id='1'
and DATE_FORMAT(c.birth_date,'%m')='${会员生日月份}'
and card_type_name in ('${REPLACE(卡类型,",","\',\'")}')
and gender in ('${REPLACE(性别,",","\',\'")}')
order by bonus_balance desc
a.card_no中定义的是卡号，怎么用sql截取4-19位数字，在sql中处理。
