title: PHP MYSQL Select where multiple variables
body: <p>I have a table which contains a userID (candidate_id) and a skill</p>
  
  <p><a href="https://i.stack.imgur.com/QEzkz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QEzkz.png" alt="enter image description here"></a></p>
  
  <p>On a seperate table (required_skills) I have column with skills split by a comma (,) for example <code>Administrator,office</code></p>
  
  <p>I am trying to create a SELECT statement to find where a candidate has all skills listed in the 'required_skills' table.</p>
  
  <p>I have tried using an array but not knowledgeable enough in them...</p>
  
  <pre><code>$myString = "$skills";
  $myArray = explode(',', $myString);
  foreach($myArray as $my_Array){
  
  $result=mysql_query("SELECT * FROM candidate_skills WHERE skill LIKE '%$my_Array%'");
  </code></pre>
  
  <p>This obviously isn't giving me what I want as it creates a select statement for each row...</p>
  
  <p>Can anyone advise?</p>