mysql 函数应用

• mod

取余是用函数mod(numer1,number2)，其返回的值为其余数值

如：mod(id,2) = 1 返回id号是奇数的id

 

Email后缀提取

emailorg=RIGHT(EMail,LENGTH(EMail)- INSTR(EMail,'@'))

转载于:https://www.cnblogs.com/ahuo/p/10734087.html