title: mysql if column contain
body: <p>i have a table with data like this (table A)</p>
  
  <pre><code>id | key  | status
  -----------------
  1  | dg12 | done
  2  | dg12 | 
  </code></pre>
  
  <p>and like this (table B)</p>
  
  <pre><code>id   | Name  | status
  ------------------
  dg12 | Dummy | 
  </code></pre>
  
  <p>i want to update table B status with this condition</p>
  
  <p>if table A status in row 1 and 2 (i means not containing " " value) is done then dg12 status in table B is done...</p>
  
  <p>how can i do that?? using php+mysql, anyone can help please??
  thanks before</p>