Table – tbl_locations
User Input – Cabin-3A, Airoli
Query-
Select * from tbl_locations where startlocation like ‘%Cabin-3A %’ or startlocation like ‘%Airoli%’ or endlocation like ‘%Airoli%’or endlocation like ‘%Cabin-3A %’
Steps –
1.There are 2 words – Cabin-3A and Airoli.
I need to match both the words with two columns of the table.
How do I get the output?