Needed a regex to (CC)

183530 — Fri, 09 Dec 2022 22:05:18 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

topic Needed a regex to (CC) in Data Engineering