title: sql query update row if contains variable from array
body: <p>I have a table</p>
  
  <pre><code>id / product_id / var / active / price
  </code></pre>
  
  <p>the var column contains three variables separated by <code>:</code></p>
  
  <pre><code>e.g. (37:48:80)
  </code></pre>
  
  <p>i want to change the price column to a set value if var contains the right options.</p>
  
  <p>i.e.</p>
  
  <pre><code>33:38:57 through to 80 would = 450 
  33:39:57 through to 80 would = 0 
  33:40:57 through to 80 would = 0 
  33:41:57 through to 80 would = 450 
  </code></pre>
  
  <p>i would like to pass the first variable an array of the second variable and if matched update price</p>
  
  <p>my very bad sql would look like:</p>
  
  <pre><code>   UPDATE 'price' = 450 
     WHERE 'var' = 33:array(38,41 etc):array(57,58 etc)
  </code></pre>
  
  <p>i know thats really wrong but thought may help you understand what I'm trying to do.</p>