INSTR

From SQLZoo
Compatibility
INSTR(s1, s2)
EngineOKAlternative
ingresNoPOSITION(s2 IN s1)
mysqlYes
oracleYes
postgresNoPOSITION(s2 IN s1)
sqlserverNoPATINDEX('%'+s2+'%',s1)

INSTR

INSTR(s1, s2) returns the character position of the substring s2 within the larger string s1. The first character is in position 1. If s2 does not occur in s1 it returns 0.

    INSTR('Hello world', 'll') -> 3 

In this example you get the position of string 'an' within a country's name.

SELECT name,
       POSITION('an' IN name)
  FROM bbc
SELECT name,
       PATINDEX('%an%', name)
  FROM bbc
 ORDER BY name
SELECT name,
       INSTR(name, 'an')
  FROM bbc

See also

Language:Project:Language policy English  • Deutsch
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects
  • Your server today is: Dipsy