å¯ä»¥ä½¿ç¨substrå½æ°åinstrå½æ°å ±åå®ç°ï¼
å¦ï¼å符串为ï¼123-asdf-119
ç°å¨è¦æªå两个â-âä¸é´çå符串ï¼å¯ç¨å¦ä¸è¯å¥ï¼
select substr('123-asdf-119',instr('123-asdf-119','-')+1,instr('123-asdf-119','-',instr('123-asdf-119','-')+1)-instr('123-asdf-119','-')-1) from dual;æ¥è¯¢ç»æï¼
instrå½æ°ï¼
è¯æ³å¦ä¸ï¼
instr( string1, string2, start_position,nth_appearance )
substrå½æ°ï¼
substr(string,start,length)
string - æå®çè¦æªåçå符串
start - å¿ éï¼è§å®å¨å符串çä½å¤å¼å§
æ£æ° - å¨å符串çæå®ä½ç½®å¼å§
è´æ° - å¨ä»å符串ç»å°¾çæå®ä½ç½®å¼å§
0 - å¨å符串ä¸ç第ä¸ä¸ªå符å¤å¼å§
length - å¯éï¼æå®è¦æªåçå符串é¿åº¦ï¼ç¼ºçæ¶è¿åå符表达å¼çå¼ç»æåçå ¨é¨å符ã