Please guide me about following case. I need to fetch records from a table which has a column like shown in the picture. I need to fetch records which has 065 and AMT campaigns only.
SELECT * FROM table WHERE Campaigns LIKE '%AMT%' OR '%065%'
Unfortunately, it is not working. Data should not be duplicated.