Replacement for LIKE
Any replacement for LIKE clause in the below query
Select count(*)
FROM XYZ A, ABC B
WHERE A.id= B.id
AND B.name like '%AB%'
ORDER BY A.id DESC;
Select count(*)
FROM XYZ A, ABC B
WHERE A.id= B.id
AND B.name like '%AB%'
ORDER BY A.id DESC;
0