SQL中使用正则的一个栗子

Select case when HEX(name) like ‘000000000000000000000000000000000000000000000000000000000000’ then ‘NODATA’ else name end as ParticipantName from abc where co = ‘1286’
and code= ‘C163210889’

Select case when REGEXP_LIKE(hex(name),’^[0]{60}$’) then ‘NODATA’ else name end as ParticipantName from abc where co = ‘1286’
and code = ‘C163210889’