xingming

SELECT * FROM `mytable` WHERE CHARACTER_LENGTH(xingming)=2SELECT CONCAT(LEFT(xingming,1),&…