title: PHP Mysql: select where array_intersect
body: <p>I need to find out those employees whose accepted working locations contain ANY of the target cities of our next construction project. That is, if there is any intersection between the target location array and the employee's desired location array, it will be OK.</p>
  
  <p>Can I query like this?</p>
  
  <pre><code>SELECT * 
    FROM employee-list
   WHERE array_intersect ($target-cities, accepted-locations) IS NOT NULL
  </code></pre>