In the Brand master table, I am getting City like this '1,2,3,4,5,6'
I want to search on this basis
select * from leaseonclick.brand_master where city like (select distinct ct.cityname from inventory inv
inner join buildingspecification bs on bs.id= inv.buildingid
inner join location loc on loc.id=bs.locationid
inner join city ct on ct.id=loc.cityid where ct.cityname like '%Gurgaon%')