title: SQL query to match one of multiple strings
body: <p>I have following data in table:</p>
  
  <pre><code>+----------------------+----------------------------------------------------------+--------------+
  | subscriber_fields_id | name                                                     | field_type   |
  +----------------------+----------------------------------------------------------+--------------+
  |                  143 | Peshawar/Islamabad/Lahore/Swat/Mardan/Karachi            | Job Location |
  |                  146 | Karachi                                                  | Job Location |
  |                  147 | Lahore and Karachi                                       | Job Location |
  |                  149 | Karachi, Mirpur Khas, Sukkur, Layyah, Gilgit, Charsaddah | Job Location |
  |                  152 | Islamabad or Lahore                                      | Job Location |
  |                  155 | Islamabad                                                | Job Location |
  |                  157 | 7 Districts of Sindh and Karachi                         | Job Location |
  +----------------------+----------------------------------------------------------+--------------+
  </code></pre>
  
  <p>My query is:</p>
  
  <pre><code>select * from subscriberfields
  where  name like '%Khairpur,Islamabad,Karachi%';
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>+----------------------+-----------------------------------------------+--------------+
  | subscriber_fields_id | name                                          | field_type   |
  +----------------------+-----------------------------------------------+--------------+
  |                  143 | Peshawar/Islamabad/Lahore/Swat/Mardan/Karachi | Job Location |
  |                  152 | Islamabad or Lahore                           | Job Location |
  |                  155 | Islamabad                                     | Job Location |
  +----------------------+-----------------------------------------------+--------------+
  </code></pre>
  
  <p>It should return all rows where the name includes Islamabad, Khairpur or Karachi but it is not.</p>