How to use like clause for a value separated with comma in Oracle

Question

In my database I have a column where the value is separated by a comma (firstname,lastname).

I am trying to search this entire field in where clause using like condition.

I have tried this:

SELECT fullname 
from users 
where ( upper( fullname ) like upper('abc, xyz'))

Answer 1

I have used regexp_like instead of only like and it worked for me.