Get first 3 letters in sql

-- 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

Get first 3 letters in sql

SELECT FIRST_NAME ,  SUBSTR(FIRST_NAME, 1 , 3 ) , LENGTH(FIRST_NAME)
FROM EMPLOYEES ;

Similar codes

2 votes166 views1 answer
Mysql create user with remote access
SQL
7 votes74 views1 answer
Mysql load data infile csv
SQL
1 vote118 views1 answer
Describe table in sql
SQL
1 vote115 views1 answer
Sql get missing id
SQL
0 vote169 views1 answer
Import sql dump into postgresql database
SQL
1 vote57 views1 answer
Oracle character set
SQL
0 vote110 views1 answer
Drop-toys-table
SQL
9 votes105 views3 answers
Mysql get last id
SQL
2 votes109 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote120 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL