Skip to Content
0

如何在hana中使用正则表达式,完成以下检索功能​

Jan 11 at 03:29 AM

36

avatar image
Former Member

请教斑竹和各路朋友一个问题:

如何在hana中使用正则表达式,完成以下检索功能

例如:select [a] from [Table_1] where regexp_like([a],'[0-9]*e[0-9]*');

即:匹配字段[a]中,含有字母'e',且两边都是数字的情况。

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers