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?
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%'