Please solve this query

Jitendra Kumar

8y895Learn iOS Programming

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jitendra Kumar8y ago
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 (',' + RTRIM(ct.cityName) + ',') LIKE '%Gurgaon%'

result: -Gurgaon

when I using this

select * from dbo.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 (',' + RTRIM(ct.cityName) + ',') LIKE '%Gurgaon%'
)

then it not working because the brand_master table has City column in nvarchar(100)

then we can not do join in this statement

It can be possible by loop because it is first statements select * from dbo.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 (',' + RTRIM(ct.cityName) + ',') LIKE '%Gurgaon%')

then it was a second one.
then please tell me about it

then you can tell me how can I use the loop in this statements
0
Faisal Pathan8y ago
WHERE (',' + RTRIM(ct.cityName) + ',') LIKE '%Gurgaon%'
0
Jignesh Kumar8y ago
Please find below query which will help select * from yourTableName where',' || columnName || ','LIKE'%,SearchValue,%'
0
Faisal Pathan8y ago
replace with this where ct.cityname like '%Gurgaon%')
0
Jitendra Kumar8y ago
can you explain this

How can i make SQL querry
0
Faisal Pathan8y ago
May it helps you.
WHERE (',' + RTRIM(yourColumnName) + ',') LIKE '%,' + @Search + ',%'
0