Please solve this query

Question

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