Have fun<br><br>SELECT coluna1, COUNT(1)<br>FROM user<br>GROUP BY coluna1 desc<br>HAVING COUNT(1) &gt; 1<br><br><div><span class="gmail_quote">2008/1/21, Rodrigo Panchiniak Fernandes &lt;<a href="mailto:fernandes@cpan.org">
fernandes@cpan.org</a>&gt;:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Salve,<br><br>Numa das colunas da minha tabela há strings repetidas.
<br>Eu queria que dump_results mostrasse apenas as linhas<br>nas quais ocorre a repetição.<br><br>Algo como:<br>&quot;SELECT<br>&nbsp;&nbsp;&nbsp;&nbsp;coluna1 TEXT<br>FROM user<br>&nbsp;&nbsp;&nbsp;&nbsp;WHERE<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;/linha anterior/ =~ /linha atual/<br>&nbsp;&nbsp;&nbsp;&nbsp;ORDER BY
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;coluna1 desc&quot;;<br><br>Alguém pode explicar uma forma simples de fazer isto?<br><br>[]s<br><br>Rodrigo<br><br><br><br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;____________________________________________________________________________________
<br>Be a better friend, newshound, and<br>know-it-all with Yahoo! Mobile.&nbsp;&nbsp;Try it now.&nbsp;&nbsp;<a href="http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ">http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ</a><br>
<br><br>_______________________________________________<br>Cascavel-pm mailing list<br><a href="mailto:Cascavel-pm@pm.org">Cascavel-pm@pm.org</a><br><a href="http://mail.pm.org/mailman/listinfo/cascavel-pm">http://mail.pm.org/mailman/listinfo/cascavel-pm
</a><br></blockquote></div><br><br clear="all"><br>-- <br>Em breve: <a href="http://www.Empregar.com">www.Empregar.com</a><br>Wiki sobre MySQL: <a href="http://MySQL-BR.wikidot.com">MySQL-BR.wikidot.com</a>