Comments by Member 10861672 (Top 6 by date)

|-----D--------|---W----|---X---|------Z--------|------AA-------|----------AB-------------|-AC--|---------AD------------|
!______________!________!_______!_______________!_______________!_________________________!_____!_______________________!
|S.B.I. ATM----|Bhilai--|Durg---|Smriti Nagar---|Junwani Road---|Infront Of Jaika Bakery--|ATM--|State Bank Of India ATM|
|Axis Bank ATM-|Bhilai--|Durg---|Shop No 106----|Smriti Nagar---|CHPL Complex-------------|ATM--|Axis Bank ATM----------|
|S.B.I.ATM-----|Bhilai--|Durg---|Khursipar Gate-|G.E. Road------|Bansi Bazaar-------------|ATM--|State Bank Of India ATM|
|AXIS ATM------|Bhilai--|Durg---|Khursipar Gate-|G.E. Road------|Bansi Bazaar-------------|ATM--|Axis Bank ATM----------|
|B.O.I.ATM-----|Bhilai--|Durg---|Khursipar Gate-|G.E. Road------|Bansi Bazaar-------------|ATM--|Bank Of India ATM------|
|H.D.F.C.ATM---|Bhilai--|Durg---|Khursipar Gate-|G.E. Road------|Bansi Bazaar-------------|ATM--|H.D.F.C. ATM-----------|

The above table is ABC.
and the Query is

SELECT D,W,X,Z,AA,AB,AC,AD
FROM ABC WHERE (D LIKE 'S.B.I.%' OR
D LIKE 'ATM%' OR
D LIKE 'BHILAI%' OR
D LIKE 'G.E.%') AND (W LIKE 'S.B.I.%' OR
W LIKE 'ATM%' OR
W LIKE 'BHILAI%' OR
W LIKE 'G.E.%') AND (X LIKE 'S.B.I.%' OR
X LIKE 'ATM%' OR
X LIKE 'BHILAI%' OR
X LIKE 'G.E.%') AND (Z LIKE 'S.B.I.%' OR
Z LIKE 'ATM%' OR
Z LIKE 'BHILAI%' OR
Z LIKE 'G.E.%') AND (AC LIKE 'S.B.I.%' OR
AC LIKE 'ATM%' OR
AC LIKE 'BHILAI%' OR
AC LIKE 'G.E.%')