topic Re: i need a regex to get whole word with parentheses in Data Engineering

i need a regex to get whole word with parentheses

183530 — Fri, 09 Dec 2022 22:07:05 GMT

SELECT '(CC) ABC' REGEXP '\\b\\(CC\\)\\b' AS TEST1,

'A(CC) ABC' REGEXP '\\b\\(CC\\)\\b' AS TEST2,

'A (CC)A ABC' REGEXP '\\b\\(CC\\)\\b' AS TEST3,

'A (CC) A ABC' REGEXP '\\b\\(CC\\)\\b' AS TEST4,

'A ABC (CC)' REGEXP '\\b\\(CC\\)\\b' AS TEST5

expected result:

TEST1 = TRUE

TEST2 = FALSE

TEST3 = FALSE

TEST4 = TRUE

TEST5 = TRUE

Hubert-Dudek — Sat, 10 Dec 2022 12:45:58 GMT

Please share the expected output and what is condition for True and False.

183530 — Sat, 10 Dec 2022 14:47:37 GMT

get whole word "(CC)"

I had already written the output

expected outuput

'(CC) ABC' REGEXP <<regex>> = TRUE

'A(CC) ABC' REGEXP <<regex>> = FALSE

'A (CC)A ABC' REGEXP <<regex>> = FALSE

'A (CC) A ABC' REGEXP <<regex>> = TRUE

'A ABC (CC)' REGEXP <<regex>> = TRUE