title: How to select rows where field is not blank/empty
body: <p>I'm trying to do a MySQL query in phpMyAdmin. I want to find an entry where fieldone is not NULL or is not empty/blank as I inherited the system so fields are set to NULL and some are just blank.</p>
  <p>Anyways, Here is the query I'm trying</p>
  <pre><code>SELECT fieldone, fieldtwo
  FROM tableone
  WHERE fieldone != ' '
  OR fieldone IS NOT NULL
  </code></pre>
  <p>And</p>
  <pre><code>SELECT fieldone, fieldtwo
  FROM tableone
  WHERE fieldone &lt;&gt; ' '
  OR fieldone IS NOT NULL
  </code></pre>
  <p>Both show an error #1064 on the line that contains</p>
  <pre><code>WHERE fieldone != ' '
  </code></pre>
  <p>And</p>
  <pre><code>WHERE fieldone &lt;&gt; ' '
  </code></pre>
  <p>The NOT NULL part works great, its just trying to find any fields that are blank.</p>