Essential Books

INSTR

suggest change

Return the index of the first occurrence of a substring (zero if not found)

Syntax: INSTR ( string, substring ) 

SELECT INSTR('FooBarBar', 'Bar') -- return 4
SELECT INSTR('FooBarBar', 'Xar') -- return 0
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

String Functions:
*String Functions
*Concatenate
*Length
*Trim empty spaces
*Upper lower case
*Split
*Replace
*Stuff
*Substring
*REGEXP
*LEFT - RIGHT
*REVERSE
*REPLICATE
*Replace function in sql Select and Update query
*PARSENAME
*INSTR
Table Of Contents