My problem is this:
When I use a keyword with like as %abc, xyz% it is showing results, but when I use xyz,abc with like as %xyz,abc% it's not showing any results because the pattern is not matched.
Is there any way for this problem?
Use 2 seperate like conditions
select * from your_table
where your_column like '%abc%'
and your_column like '%xyz%'
use OR
where your_column like '%abc%'
OR your_column like '%xyz%'