INSTR

来源：互联网发布：html获取form表单数据编辑：程序博客网时间：2024/06/05 10:39

放在一般的数据库就能执行，可以看下效果。

SELECT INSTR(’字符串1‘， ’字符串2‘属于’字符串1‘中的一个，从’字符串1‘中第几个开始，开始后的第几个‘字符串2’) FROM 表；

SELECT INSTR (STRING, STRING1 in STRING, the counter, the byter)
FROM the table;

SELECT LENGTH ('abkdajlkgjlaskjglkdjieahg')
FROM DUAL;--will return 5

SELECT INSTR ('abkdajlkgjlaskjglkdjieahg', 'a')
FROM DUAL;-- will return 1

SELECT INSTR ('abkdajlkgjlaskjglkdjieahg', 'a', 1, 1)
FROM DUAL;-- will return 1

SELECT INSTR ('abkdajlkgjlaskjglkdjieahg', 'a', 1, 2)
FROM DUAL;--will return 5

SELECT INSTR ('abkdajlkgjlaskjglkdjieahg', 'a', 1, 3)
FROM DUAL;--will return 12

SELECT INSTR ('abkdajlkgjlaskjglkdjieahg', 'a', 1, 4)
FROM DUAL;--will return 23

SELECT INSTR ('abkdajlkgjlaskjglkdjieahg', 'a', 2, 1)
FROM DUAL;--will return 5

SELECT INSTR ('abkdajlkgjlaskjglkdjieahg', 'a', 2, 2)
FROM DUAL;--will return 12

SELECT INSTR ('abkdajlkgjlaskjglkdjieahg', 'a', -1, 1)
FROM DUAL;--will return 23

SELECT INSTR ('abkdajlkgjlaskjglkdjieahg', 'a', -1, 2)
FROM DUAL;--will return 12

SELECT INSTR ('abkdajlkgjlaskjglkdjieahg', 'a', -2, 3)
FROM DUAL;--will return 5