Sql substring

Sql server substring

SELECT SUBSTRING('SQL Tutorial', 1, 3) AS ExtractString;

Sql substring

-- substr(string, start, [, length ])
SELECT substr('Hello World', 1, 3) ;      -- Hel
SELECT substr('Hello World', 4, 5) ;      -- lo Wo
SELECT substr('Hello World', 4);          -- lo World
SELECT substr('Hello World', -3);         -- rld

Grab part of a string sql

SELECT 
    SUBSTRING('SQLTutorial.org',
        POSITION('.' IN 'SQLTutorial.org'));

Source: sqltutorial.org

Grab part of a string sql

SELECT SUBSTRING('SQLTutorial.org');

Source: sqltutorial.org

Sql substring

SELECT SUBSTRING(your String here, Int Start, String length) AS OutPutString;

Similar codes

24 votes113 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
1 vote115 views1 answer
Oracle case
SQL
0 vote111 views1 answer
Raiserror nowait sql server
SQL
4 votes120 views2 answers
Installing sql on ubuntu
SQL
14 votes117 views3 answers
SQL trim
SQL
16 votes115 views4 answers
Sort by sql
SQL
-1 vote117 views1 answer
Mysql select all columns and specific fields as
SQL
4 votes125 views2 answers
Bulk kill mysql processlist
SQL
0 vote131 views1 answer
Object of class mysqli_result could not be converted to string
SQL
1 vote109 views1 answer
User privileges postgresql information_schema
SQL