解释SELECT distinct ICD10 FROM tb_acc_importhistory WHERE not REGEXP_LIKE(ICD10,'[\u4e00-\u9fa5]');
时间: 2024-05-31 10:08:29 浏览: 115
这是一条SQL查询语句,查询的是tb_acc_importhistory表中ICD10字段的不重复值,且ICD10字段不包含中文字符的记录。
其中,REGEXP_LIKE是一个正则表达式函数,用于判断一个字符串是否符合某种正则表达式的模式。[\u4e00-\u9fa5]代表中文字符的unicode编码范围,所以这个正则表达式的含义是判断ICD10字段是否包含中文字符。not关键字表示取反,所以not REGEXP_LIKE(ICD10,'[\u4e00-\u9fa5]')的含义是ICD10字段不包含中文字符。
相关问题
SELECT distinct ICD10 FROM tb_acc_importhistory WHERE not REGEXP_LIKE(ICD10,'[\u4e00-\u9fa5]');
As an AI language model, I cannot access your database. However, the SQL query you provided selects distinct ICD10 codes from the "tb_acc_importhistory" table where the ICD10 code does not contain any Chinese characters. The regular expression used in this query ensures that only non-Chinese characters are present in the ICD10 code.
阅读全文