MariaDB: INSTR Function
This MariaDB tutorial explains how to use the MariaDB INSTR function with syntax and examples.
Description
The MariaDB INSTR function returns the location of a substring in a string.
Syntax
The syntax for the INSTR function in MariaDB is:
INSTR( string, substring )
Parameters or Arguments
- string
- The string to search.
- substring
- The substring to search for in string.
Note
- The first position in string is 1.
- When finding the location of a substring in a string, the INSTR function does not perform case-sensitive search.
- If substring is not found in string, then the INSTR function will return 0.
Applies To
The INSTR function can be used in the following versions of MariaDB:
- MariaDB 10
Example
Let's look at some MariaDB INSTR function examples and explore how to use the INSTR function in MariaDB.
For example:
SELECT INSTR('TechOnTheNet.com', 'T'); Result: 1 SELECT INSTR('TechOnTheNet.com', 't'); Result: 1 SELECT INSTR('TechOnTheNet.com', 'h'); Result: 4 SELECT INSTR('TechOnTheNet.com', '4'); Result: 0
Advertisements