title: Mysql select row containing string + specific int column comparison
body: <p>I have found numerous questions related to mine but still can't solve this issue.</p>
  
  <p>In my table there are 3 columns filled with integer values and 3 columns with string values. I have several rows.</p>
  
  <p>Table structure example:</p>
  
  <pre><code>  INT_1 | INT_2 | INT_3 | VALUE1 | VALUE2 | VALUE3
     33   |  25   |   10  | "nice"| "hello"| "goodbye"
    ---------------------------------------------------
     10   |  15   |   28  | "dice"| "hay"  | "bird"
  </code></pre>
  
  <p>I have a <strong>string</strong> that I use to select the rows based on the VALUE columns. The way I want to select it is with inclusion which means if the string is "llo" I should get the row where <strong>at least</strong> one of the values (VALUE,VALUE2,VALUE3) contains "llo" (would select the row with "hello" in VALUE2, for example).</p>
  
  <p>However if two different rows have VALUE columns that contain the string (like in the example if the string is "ice") I want to retrieve the row where the INT column associated to that VALUE is higher. In the example since the string was compared to VALUE1 I should compare INT_1 of the upper column with INT_1 of the lower column and retrieve the row where INT_1 is higher. (INT_1 -> VALUE1, INT_2 -> VALUE2, INT_3 -> VALUE3).</p>
  
  <p>Well not much but I could figure this myself: </p>
  
  <pre><code> SELECT * FROM my_table WHERE VALUE1 = "+string+" OR VALUE2= "+string+" OR VALUE3= "+string+"";
  </code></pre>
  
  <ul>
  <li>I am not sure how should I include "LIKE" to check for containing string when I have the values like "+string+".</li>
  <li>I don't know how to compare the specific INT column with the specific VALUE column when I have more than one row where VALUE contains the string. </li>
  </ul>