title: mysql (5.1) > select * from database.table where not foo (on all fields)
body: <p>I want to select everything in a table where the cell's value is not <code>foo</code>. I thought it would be something similar to <code>WHERE NOT NULL</code>, like <code>SELECT * FROM database.table WHERE NOT 'foo';</code>, but that just returned the column headers with no data.</p>
  
  <p><strong>edit</strong>: i want to do this <em>without</em> specifying a particular column (<code>NOT 'foo'</code> for all fields).</p>