title: Compare two PostgreSQL columns with strings separated by slash "/" or parentheses "( )"
body: <p>I am fairly new to Rails/PostgreSQL and just got stuck on this seemingly simple problem.</p>
  
  <p>How do I compare string values of two columns when one column contains multiple string values of the same thing in different languages separated by either slash "/" or parentheses "( )"?</p>
  
  <pre><code>ID |    Drink #1   |     Drink #2
   1 |      Water    |   Agua/Water/Eau
   2 |    Magnesium  | Magnesio (Magnesium)
  </code></pre>
  
  <p>I am primarily looking for a PostgreSQL query to display in the view "Both Drink #1 and Drink #2 contain Water and Magnesium", but I am also wondering if there could be other ways using a controller (C of MVC). I searched for relevant Rails Gems, but no success after many hours.  </p>
  
  <p>Thank you all!</p>