SELECT LOWER(ename) FROM user SELECT CONCAT(name,ename) FROM user SELECT j.* FROM (SELECT * FROM USER WHERE SUBSTRING(personId FROM 7 FOR 4)=1992)c,card g,transinfo j WHERE c.userId=g.userId and j.cardNo=g.cardNo
SELECT SUBSTRING(NAME FROM 1 FOR 1)F,COUNT(cardNo) FROM USER Q,card W WHERE Q.userId=W.userId GROUP BY F SELECT * FROM user WHERE LENGTH(NAME)=6 SELECT CONCAT(SUBSTRING(personId FROM 7 FOR 4),'-',SUBSTRING(personId FROM 11 FOR 2),'-',SUBSTRING(personId FROM 13 FOR 2)) FROM user