Needed a regex to (CC)
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2022 02:05 PM
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
0 REPLIES 0

