Difference between revisions of "Regular expressions"
From MyWiki
| Line 1: | Line 1: | ||
http://www.tutorialspoint.com/mysql/mysql-introduction.htm<br> | http://www.tutorialspoint.com/mysql/mysql-introduction.htm<br> | ||
http://www.tutorialspoint.com/mysql/mysql-regexps.htm<br> | http://www.tutorialspoint.com/mysql/mysql-regexps.htm<br> | ||
| + | |||
| + | '''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> | ||
Revision as of 12:32, 4 October 2014
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>
