<?xml version="1.0" encoding="UTF-8"?><!-- generator="wordpress/2.2.3" -->
<rss version="0.92">
<channel>
	<title>Dryice Liu's Blog</title>
	<link>http://dryice.name/blog</link>
	<description></description>
	<lastBuildDate>Tue, 31 Aug 2010 12:01:11 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>mysql tip: finding duplicated records</title>
		<description>Found here: http://mysql-tips.blogspot.com/2005/04/mysql-find-duplicate-repords-example.html

select address, count(address) as cnt
from mailing_list
group by address
having cnt &#62; 1
order by cnt;

Share This
 </description>
		<link>http://dryice.name/blog/misc/mysql-tip-finding-duplicated-records/</link>
			</item>
</channel>
</rss>

