title: Select row from table where column value is subset of value passed in stored procedure
body: <p>I have a table with columns and data something like this</p>
  
  <pre><code>+------+-------------------------+-------------+--------------+
  | name | search_name             | client_name | display_name |
  +------+-------------------------+-------------+--------------+
  | J&amp;J  | J&amp;J | Johnson &amp; Johnson | Janssen     | J&amp;J          |
  +------+-------------------------+-------------+--------------+
  </code></pre>
  
  <p>now i want to create a stored procedure that will pass a string lets say <strong>"Johnson &amp; Johnson company" or "J&amp;J company"</strong> and storproc should match the passed string with all the columns data and if any of the column value is subset of passed value so storproc should select that row or count of row(anything would be fine).</p>
  
  <p>to be more precise if I pass "J&amp;J company" in storproc and name column contain "J&amp;J"(which is a subset of passed value) so storproc should return above row or count of row(anything would be fine).</p>
  
  <p>PS : this is just a sample data original table contains more that 47000 rows so I can't do this in php level.</p>
  
  <p>I have to do just opposite of 'LIKE' operator in mysql where in LIKE you pass a subset of string and table contains superset but in my case I have to pass a superset string and if table columns(any one) contains a subset that row should be returned.</p>
  
  <p>Hope I have elaborated the problem enough, any help would be appreciable.</p>