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