database - Mysql: link records with special characters to the very first alphabet after the special characters and retrive -

 

create table temp_surnames( last_name varchar(100) not null primary key, create_date datetime not null);  insert temp_surnames (last_name) values('$$moses’); insert temp_surnames (last_name) values(‘\'moses’); insert temp_surnames (last_name) values('moses’); insert temp_surnames (last_name) values(‘ammoses'); 

i want retreive every record except 'ammoses'. every record starts m%, if use '%m%' returned. please recommend.

a simple regular expression like:

where last_name regexp '^[^[:alpha:]]*m'