| 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中处理。 |
最佳回答 |
||||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
