select latest24_state from
( select latest24_state from zx_loan
union select latest24_state from zx_loancard
union select latest24_state from zx_standardloancard
) t
where latest24_state regexp '[^1234567/*NCDZG#]'
转载于:https://my.oschina.net/u/1255119/blog/3052523