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’

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/DiZhang/p/12545049.html