0

I want to search inside comma separated string . I know its possible by using IN operator but its return only if its match 100%. I want like WHERE ban IN ('apple', 'banana', 'coconut','bangladesh') where ban will match banana ,bangladesh . Sorry for my bad English and advanced thanks for all .

MD ANWAR JAHID
  • 19
  • 1
  • 6
  • 1
    Hint: `Like %..%` – Madhur Bhaiya Nov 05 '18 at 04:02
  • You can use multiple LIKE with OR clause [refer this link ](https://stackoverflow.com/questions/2318126/using-sql-like-and-in-together) – PDS Nov 05 '18 at 04:10
  • 2
    Possible duplicate of [Using SQL LIKE and IN together](https://stackoverflow.com/questions/2318126/using-sql-like-and-in-together) – Madhur Bhaiya Nov 05 '18 at 04:11
  • You can use multiple LIKE with OR clause [Reference](https://stackoverflow.com/questions/2318126/using-sql-like-and-in-together) – PDS Nov 05 '18 at 04:17
  • Thanks all of you . If use reverse it like Where bangladesh IN ('Ban','Bana') is it possible by anyhow ? – MD ANWAR JAHID Nov 05 '18 at 05:10
  • Please provide some examples of what you want to succeed _and_ some that should fail. (It may be easier to show examples than to struggle with English.) – Rick James Nov 05 '18 at 22:28

0 Answers0