sql正则查询

select fld_UId,fld_UserName from user where fld_UserName REGEXP '^[1]+@[A-Z0-9.-]+.[A-Z]{2,4}$';

---

1. A-Z0-9._%- ↩︎