-- 匹配数字开头--
select t.member_mobile from shopnc_member_custom t where t.member_mobile REGEXP '^[0-9]';
-- 匹配字母开头--
select t.member_mobile from shopnc_member_custom t where t.member_mobile REGEXP '^[a-z]';
结果
-- 匹配数字开头--
select t.member_mobile from shopnc_member_custom t where t.member_mobile REGEXP '^[0-9]';
-- 匹配字母开头--
select t.member_mobile from shopnc_member_custom t where t.member_mobile REGEXP '^[a-z]';
结果