title: How to search in mysql for a word that contains in a PHP variable?
body: <p>I have multiple variables that contains customer names and looks like for example as below:</p>
  
  <pre><code>$customer =  $row["customer_name"];
  </code></pre>
  
  <p>This will contain i.e.: <code>test Microsoft test test test</code></p>
  
  <p>Now, in my database I have the column <code>customer</code> and the column contains <code>Microsoft Netherlands Office</code></p>
  
  <p>To look into the database, I have like below but it doesn't give me any results: </p>
  
  <pre><code>$query="SELECT * FROM specific_req WHERE customer LIKE '%$customer%'";
  </code></pre>
  
  <p>I want to search in the database table that contains any word from <code>$customer</code>.</p>