SUBSTR() å½æ°
ä»ä¸ä¸ªå符串æå¤æ³¨åå段ä¸æªåä¸é¨åè¿åã
SUBSTR( åç¬¦è¡¨è¾¾å¼ , å¼å§æªåçä½ç½®, æªåçé¿åº¦)
è¿å¼ç±»å ï¼å符å ï¼
åæ°æè¿°
åç¬¦è¡¨è¾¾å¼ ï¼å°ä»è¿ä¸ªå符表达å¼ï¼æå符串ï¼ä¸æªåã
å¼å§æªåçä½ç½® ï¼æå®ä»ç¬¬å 个å符å¼å§æªåã
å¦æå¼å§ä½ç½®å¤§äºå符çæ»é¿åº¦ï¼å¨ set talk on çæ
åµä¸å°è¿åé误信æ¯ï¼å¦ set talk offï¼åè¿å空å符串ã
æªåçé¿åº¦ ï¼æå®æªåå¤å°ä¸ªå符ï¼å¦çç¥ï¼åä»å¼å§å°æåã
示ä¾
substr('FOXPROç±å¥½è
ç天å ',7,3)
æ¾ç¤ºï¼ç±å¥½è
å¦æä¸ä¸ª SUBSTRC() å½æ°ï¼è¿ä¸ªå½æ°å°æ±åå½ä¸¤ä¸ªå符å¤çï¼æ³¨æå¯å«æªåå°å个æ±åçæ
åµåï¼ã
温馨提示:答案为网友推荐,仅供参考