<div class="gmail_quote">On Mon, May 23, 2011 at 5:47 AM, Ian Clark <span dir="ltr"><<a href="mailto:mrrooster@gmail.com">mrrooster@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">Just fyi, If you run:</div>
<br>
select count(*) from settings group by hostname,value,data having count(*) > 1;<br>
<br>
it will return an empty set if there are no duplicates.<br>
<br>
Cheers,<br>
<font color="#888888"><br>
Ian<br>
</font><div><div></div><div class="h5"></div></div></blockquote></div><br><div>Thanks Ian, that worked great. I tried it with your line and also with hostname,value and got empty set for both so I think I'm good as far as the settings table in the database is concerned.</div>