SUBSTRING(ansi)
From SQLZoo
SUBSTRING(s FROM i FOR j) | ||
---|---|---|
Engine | OK | Alternative |
ingres | Yes | SUBSTRING(s,i,j) |
mysql | Yes | |
oracle | No | SUBSTR(s,i,j) |
postgres | Yes | SUBSTRING(s,i,j) |
sqlserver | No | SUBSTRING(s,i,j) |
SUBSTRING (ansi)
SUBSTRING allows you to extract part of a string.
SUBSTRING('Hello world' FROM 2 FOR 3) -> 'ell'
In this example you get the 2nd to 5th character from each country's name.
SELECT name,
SUBSTRING(name, 2, 5)
FROM bbc
SELECT name,
SUBSTR(name, 2, 5)
FROM bbc
SELECT name,
SUBSTRING(name FROM 2 FOR 5)
FROM bbc
See also
Language: | English • Deutsch |
---|