<div>
I found that this also works:<br />

<pre><code id="code-8072099">SELECT * FROM `abc` WHERE length(xyz)&gt;0</code></pre>
</div>


I found that this also works:


SELECT * FROM `abc` WHERE length(xyz)>0

<div>
<div class="content wysiwyg-content">
How can I specify where a table is not empty? &nbsp;<br />
<br />
A table is empty if it is null or if it contains nothing or if it only contains whitespace.<br />

<pre><code id="code-8029295">SELECT * FROM `abc` WHERE `xyz` NOT EMPTY</code></pre>
</div>
</div>


How can I specify where a table is not empty?  

A table is empty if it is null or if it contains nothing or if it only contains whitespace.

MySQL: Not empty

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.