select * from table where length(title)<=4 SELECT serialnum,CONCAT('AAAAA-',(SUBSTRING_INDEX(serialnum, '-', -1))) FROM servicenet