SQL & PL/SQL

Hi All,

Please help me to know how to make sure REGEXP_COUNT match whole word and modify SQL statement.
I've a string comma separated like 'AB, CD, EF’

SQL: I am searching with ‘AB’

SELECT REGEXP_COUNT ('AB,CD,EF','AB',1,'i') from dual;--True
SELECT REGEXP_COUNT ('AB,CD,EF','A',1,'i') from dual;--False,should return 0
SELECT REGEXP_COUNT ('AB,CD,EF','BA',1,'i') from dual;--False,should return 0

Thanks,