<div>
Thank you both. &nbsp;hielo, I modified your code to make it work. &nbsp;<br />
<br />
wpcortes, your code works as is.<br />
<br />

<pre><code id="code-8158825">SELECT `Name`,`ID` FROM `File` WHERE `File`.`ClassName` = 'Folder' 
AND `File`.`ID` IN (SELECT `f2`.`ParentID` FROM `File` as `f2` WHERE `f2`.`ParentID`=`File`.`ID`)</code></pre>
</div>


Thank you both.  hielo, I modified your code to make it work.  

wpcortes, your code works as is.



SELECT `Name`,`ID` FROM `File` WHERE `File`.`ClassName` = 'Folder' 
AND `File`.`ID` IN (SELECT `f2`.`ParentID` FROM `File` as `f2` WHERE `f2`.`ParentID`=`File`.`ID`)

<div>
<div class="content wysiwyg-content">
With MySQL, I want to limit results to items with at least one child item.<br />
<br />
My table has a column named `ParentID` and I only want results where at least one item uses the item returned as its `ParentID`<br />
<br />

<pre><code id="code-8158799">SELECT `Name`,`ID` FROM `File` WHERE `ClassName` = 'Folder' AND  (there is at least one `File` with the `ParentID` of this `ID`)</code></pre>
</div>
</div>


With MySQL, I want to limit results to items with at least one child item.

My table has a column named `ParentID` and I only want results where at least one item uses the item returned as its `ParentID`


MySQL: limit results to items with at least one child item

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.