vim: convert the ^M linebreak to 'normal' linebreak

^M is ctrl+v and ctrl+M
:%s/^M/\r/g

mysql group by and having

mysql> select CASNumber, count(CASNumber) as ccas from compounds group by CASNumber having ccas=1 order by ccas ;