Skip to content

Instantly share code, notes, and snippets.

View doolittlece's full-sized avatar

Casey Doolittle doolittlece

2 followers · 2 following
View GitHub Profile
@doolittlece
doolittlece / Email Regex
Created December 5, 2014 21:22
"^[A-Za-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\\.[A-Za-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[A-Za-z0-9](?:[A-Za-z0-9-]*[A-Za-z0-9])?\\.)+(?:[A-Za-z]{2}|[Ee][Dd][Uu]|[Cc][Oo][Mm]|[Oo][Rr][Gg]|[Nn][Ee][Tt]|[Gg][Oo][Vv]|[Mm][Ii][Ll]|[Bb][Ii][Zz]|[Ii][Nn][Ff][Oo]|[Mm][Oo][Bb][Ii]|[Nn][Aa][Mm][Ee]|[Aa][Ee][Rr][Oo]|[Jj][Oo][Bb][Ss]|[Mm][Uu][Ss][Ee][Uu][Mm])$""
@doolittlece
doolittlece / duplicate.sql
Created November 5, 2013 16:17
Find duplicate records in an sql search, got this from http://www.bmchild.com/2013/06/sql-find-duplicate-rows-for-one-or-more.html and want to make sure I had it somewhere.
select field1,field2,field3, count(*)
from table_name
group by field1,field2,field3
having count(*) > 1