REGEXP_LIKE exclude strings

Question

How can I exclude next below strings using REGEXP_LIKE.

When the next character of 'TEST' string is - or . or @

Examples:

   [email protected]
   [email protected]
   [email protected]
   [email protected]
   [email protected]

But include:

[email protected]
[email protected]

piet.t · Accepted Answer · 2013-11-26 07:17:15Z

1

try

...
WHERE NOT REGEXP_LIKE(field,'TEST[-.@]')

answered Nov 26, 2013 at 7:17

piet.t

11.9k21 gold badges45 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dba · Accepted Answer · 2013-11-26 07:50:34Z

1

Try like this,

WITH t AS (
           SELECT '[email protected]' COL1
             FROM dual
            UNION   
           SELECT '[email protected]'
             FROM dual
            UNION  
           SELECT '[email protected]'
             FROM dual
            UNION  
           SELECT '[email protected]'
             FROM dual
            UNION  
           SELECT '[email protected]'
             FROM dual
          )     
SELECT t.col1
  FROM t
WHERE NOT REGEXP_LIKE(COL1,'TEST[-.@]')
;

edited Nov 26, 2013 at 7:50

answered Nov 26, 2013 at 7:24

Dba

6,6791 gold badge26 silver badges33 bronze badges

1 Comment

piet.t Over a year ago

You should remove the ^ to match [email protected]

Collectives™ on Stack Overflow

REGEXP_LIKE exclude strings

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related