title: MySQL how to check if any value in a list of columns is NULL?
body: <p>I would like to select the entries in a mysql table where there are NULL values, to later do an update or a delete on them:</p>
  
  <pre><code>select * from table where q is NULL;
  </code></pre>
  
  <p>But I have a rather long list of them, in this case all with a given prefix called <code>pf_</code>, and I want to select the entries where any of the columns is NULL. Can I do something like this?</p>
  
  <pre><code>select * from table where ANYISNULL(pf_q,pf_w,pf_e,pf_r,pf_t,pf_y,pf_u,pf_i,
                                      pf_o,pf_p,pf_a,pf_s,pf_d,pf_f,pf_g,pf_h,
                                      pf_j,pf_k,pf_l);
  </code></pre>
  
  <p>Any ideas how to do this other than having a very long query with lots of ORs?</p>