如果id=4,note="11a1324t3A2343"，表名为r_genre，那么SELECT CONCAT(substring_index(SUBSTR(note FROM 3),'A',1),"A") FROM r_genre where id=4;
