Regular expressions

http://www.tutorialspoint.com/mysql/mysql-introduction.htm
http://www.tutorialspoint.com/mysql/mysql-regexps.htm

Example <sourec lang="sql">

mysql> select uid,whencreated,employeetype,mail,proxyaddresses from adfields where employeeType='Student' and proxyaddresses not like '%alumni%' and proxyaddresses not regexp 'smtp:[a-z]{2,3}[0-9]' and mail not regexp '^[a-z]{2,3}[0-9]' order by whencreated desc  ;

</source>