title: Split String to Array and do a like to match value in another column
body: <p>I have two columns to compare in a MYSQL table and wanted to split the value of first column to an array and look for any of these values in arrays matches with the values in array of second columns. Here is an example:</p>
  
  <pre><code>Column1                     Column2
  Walmart Supercenter         Walmart Sams
  Home                        Home Depot
  3M Logistics Co.            3M
  </code></pre>
  
  <p>if my approach is something like this then it will never match</p>
  
  <pre><code>column2 like concat('%',column1,'%')
  </code></pre>
  
  <p>What I am looking for:</p>
  
  <pre><code>column2 like concat('%',column1[0],'%') or column2 like concat('%',column1[1],'%')
  </code></pre>